Friday, February 17, 2012

database creation durations

Trying to bring up a server at a DR site and running into what I think are
excessive durations for .mdf / .ndf file creation. It takes SQL server 1.5
hours to grab each 50 GB file. Disk subsystem at the site is a local
Ultra-Wide SCSI. RAID5 array.
Is 1.5 hours for a 50 GB excessive? What metrics can I use to monitor?
Oscar Elleseff
Is this a 3 disk Raid 5? If so that is the worst performing Raid array you
can have for write intensive operations. Depending on the processors and
disks this may not be out of the question. If you upgrade to SQL2005 you
can take advantage of the zero-initialization feature for data files and
this will be cut down to probably a minute or less.
Andrew J. Kelly SQL MVP
"Oscar" <Oscar@.discussions.microsoft.com> wrote in message
news:B9334E0E-8AF1-4C79-9E0D-5E909C541E54@.microsoft.com...
> Trying to bring up a server at a DR site and running into what I think are
> excessive durations for .mdf / .ndf file creation. It takes SQL server
> 1.5
> hours to grab each 50 GB file. Disk subsystem at the site is a local
> Ultra-Wide SCSI. RAID5 array.
> Is 1.5 hours for a 50 GB excessive? What metrics can I use to monitor?
>
> Oscar Elleseff
>
>
>

No comments:

Post a Comment