I setup a perfmon collector to capture data around some recent SQL Server command timeout errors and most indicators point to disk issues. CPU and memory numbers look normal. This is a SQL Server 2008 physical server with 2 disks. SQL data files reside on a one disk (RAID 5) and SQL log files on another.
At the time of the errors these particular counters are way beyond normal (about 10x worse than normal):
- % Disk Time
- Disk Reads/Sec (on the data disk)
- Disk sec/Read (on the data disk)
- SQLServer:Buffer Manager\Page life expectancy
With these perfmon findings, what would the next step be to isolate the problem? Running SQL Profiler?