Also, perhaps the index records on a tape or tapes used for the restore has become corrupt, and the slow restore time could be due to the tape index being rebuilt as as TSM seeks through the tape.
Matt. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Stapleton, Mark Sent: Tuesday, October 26, 2004 7:57 PM To: [EMAIL PROTECTED] Subject: Re: Poor restore performance Windows-client 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 ___________________________ Disclaimer Notice __________________________ This message and any attachments are confidential and should only be read by those to whom they are addressed. If you are not the intended recipient, please contact us, delete the message from your computer and destroy any copies. Any distribution or copying without our prior permission is prohibited. Internet communications are not always secure and therefore Powergen Retail Limited does not accept legal responsibility for this message. The recipient is responsible for verifying its authenticity before acting on the contents. Any views or opinions presented are solely those of the author and do not necessarily represent those of Powergen Retail Limited. Registered addresses: Powergen Retail Limited, Westwood Way, Westwood Business Park, Coventry, CV4 8LG. Registered in England and Wales No: 3407430 Telephone +44 (0) 2476 42 4000 Fax +44 (0) 2476 42 5432
