Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-05 : 08:17:35
|
| Barry writes "I have three test servers set up:1> SQL 7 on a pc with PIII/450 Dual Processor, 756M Memory and Caching SCZI drive array.2> SQL 2000/sp 2 on a pc with P4/1.5 Single Processore , 1G RAm and Caching SCzi Drive array.3> SQL 2000/sp 2 on an IBM Netfinity 5000 Series PIII/800 Dual Processor, 1G RAM and cachig sczi drive array.All run Win 2000 Server, sp 2.These are test servers and I restore the a 29G database from our production server to each of these. The backup files are located on the #3, the Netfinity machine.Sytems 1 & 2 take about 1.5 hours to do the restore. PC 3 takes about 10.5 hours. I do not understand why I would see an order of magnitude difference in the restore time, espcially when the restore files are on the pc taking the longest time.What could be causing this? Where do I look?" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-05 : 08:22:20
|
| My first guess is that the backup files are on the same drive as the data files being restored. The drive therefore can't do parallel read and write operations on machine #3. When restoring to #1 or #2, the #3 drive is simply reading/spooling off the data while the other machines are simply writing it to their drives. It still seems excessive for it to take 10 times longer though. If the backup files and data files are kept on separate drives, then the restore performance should improve. |
 |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-08-06 : 09:01:52
|
| Barry,What are the parameters of the "Caching SCZI [sic] drive array"? You've given the OS, CPU, and RAM of these boxes, which is informative but ultimately irrelevant - a restore operation is 100% I/O (especially using SCSI).If you're still working this issue, post the location of the file(s) and a detailed description of the array(s) involved.Jonathan Boott, MCDBA{0} |
|
|
|
|
|
|
|
|
SQL 2000 Restore