I am trying to restore a 200 GB database on to a newly formatted SAN
volume. The restore has been running for hours but there doesn't seem
to be a lot of disk activity on the disks I'm restoring to and I'm
wondering if that's anything to worry about.
Using perfmon I'm monitoring the % Disk time for the disk I'm restoring
to. It will show around 99% for a minute or so and then drop to zero
for 3-4 minutes. Is this normal? I know that since I'm restoring to a
new volume that SQL Server needs to zero out the 200 GB before it
starts the actual restore but I would expect to see 100% disk time
while it does this.
Any insight appreciated.
Thanks!