From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Mike Hagery >Last week we did a restore of 15 MB and 4000 small html-files. >The performance was bad, it took 57 minutes to restore the >4000 html-files and 15 MB. > >The back-up is very fast. FTP between client and server is >also fast. A restore of a big(ger) file is no problem. >Collocation is on and data is only on one tape. During restore >we see no mediawaits, so that's not the problem.
Try this select statement: select distinct volume_name from volumeusage where stgpool_name='PRIMARYSTORAGEPOOL' and node_name='YOURNODENAME' All node and storagepool entries must be in uppercase. This will tell you how many tapes you'd have to mount to restore an entire node's worth of data. Your restore problem probably stems from how scattered your data is across your primary storage pool. It has nothing to do with database fragmentation. -- Mark Stapleton ([EMAIL PROTECTED]) Berbee Information Networks Office 262.521.5627
