I'm restore a small SQL Server 2000 database (1.5 GB)
that was created on the same SAN but a different Cluster
and Server. This restore takes approximately 8 minutes
to restore on another server it takes approimately 30
seconds. What could be the problem with the restore
taking so long?

Please help me with this problem.

Thank You,

Jim

Are the disks set up the same (i.e RAID level)? That
could make a big difference.

The SAN should all be set up using all RAID 5. How would
I check the RAID level for each disk or volume?

Thank You,

Jim

"Jim" <anonymous (AT) discussions (DOT) microsoft.com> wrote


Try to create a new database of 1.5 GB size.
If it takes comparable long time - for sure it's just low write performance.
Quite often hardware guys don't configure it properly (write cache size, cache
policy, etc).

Bye, Anatol

The tools used at the low level for the SAN. If it's a
cluster, you'd have to have different partitions and such,
so it wouldn't be all one large RAID 5 I assume. You may
be doing other things.