Kraks,

Here are some of the most common sql-related perfmon monitors:

Memory: Pages/Sec

Memory: Available Bytes

Physical Disk: % Disk Time

Physical Disk: Avg. Disk Queue Length

Processor: % Processor Time

System: Processor Queue Length

SQL Server Buffer: Buffer Cache Hit Ratio

SQL Server General: User Connections

If you suspect the disk subsystem is the bottleneck, then you will see % Disk Time (Measures how busy a physical array is) spiking. A good rule of thumb is that this counter should run less than 55% for continuous periods.

Wavie davie 🙂