Optimizing Disk I/O & RAID on Windows SQL Server 2005
- by David
I've been monitoring our SQL server for a while, and have noticed that I/O hits 100% every so often using Task Manager and Perfmon.
I have normally been able to correlate this spike with SUSPENDED processes in SQL Server Management when I execute "exec sp_who2".
The RAID controller is controlled by LSI MegaRAID Storage Manager. We have the…