|
jwb
Starting Member
1 Posts |
 Posted - 11/05/2008 : 04:45:37
|
Hello,
We restored a MSSQL 2000 database, which is about 180 gb. We encountered different restore duration when we use different hardware. We wonder if the time it takes to restore is reasonable, or if there are issues with our environment.
Setup 1:
Windows 2003 R2 Enterprise
MSSQL 2000 SP3a
2x quad Intel 1.6 ghz proc
8 gb memory
Storage is in a SCSI bay with 14 disks on 1 channel, raid 5 and cache on the controller
The backup file and the target directory where to restore to is on the disk bay
Restore time took 6 hours
Setup 2:
Windows 2003 R2 Enterprise
MSSQL 2000 SP3a
1x quad Intel 2.5 ghz proc
10 gb memory
Storage is on two disk Raid 0 (SAS, controller has cache). (This is a test environment, so raid 0 is not an issue)
The backup file is on the network (1gbit) and the target directory is on the disks
Restore time took 5 hours and 20 minutes
Setup 3:
Windows 2000 SP4
MSSQL 2000 SP3a
2x Xeon 2.7 gh proc
4 gb memory
Storage is on SAN disks (EMC, FiberChannel disks)
The backup file is on a SAN disk and the directory is on another disk / LUN
Restore time took about 2 hours.
Because setup 1 uses 14 disks we hoped the restore time would faster than the six hours. Hope you can share some experience with me
If you want more information about our environment (which i can imagine, let me know).
Jeroen |
|
Restore duration
