Disk Performance - - Need Help

[rr27]

I run a SQL 2000 Enterprise Server on a Windows 2003 Enterprise Edition server with quad processors and 8GB of memory. One of my disks on my array failed this morning and I replaced it with a spare hot swap drive. Right now the performace on the SQL server is poor CPU usage is low but I/O is through the roof. IS this because the SCSI disk is resynching with the array? Is there a way to see what process is causing a bottle neck on a physical disk??

 

[SQLBill]

My guess is that the 'syncing' of data onto the hot swap is causing the problem. Rebuilding the data onto the hot swap takes a lot of I/O as it has to read from all the disks to find all the little 'check' bits that are needed.

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

I'd have to agree with SQLBill. Check into if again once the array is done rebuilding.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[aalmeida]

All,

I agree with SQL bill also, but as a suggestion to reduce I/O contention on re-sysnc disk arrays check for disk fragmentation periodically and defragmente the disk as needed.

AL Almeida
Senior DBA

http://www.saxotech.com/

"May all those that come behind us, find us faithfull"