SQL Server Performance Audit Checklist

Identify SQL Server Hardware Bottlenecks

Performance Audit Checklist

Counter Name	Average	Minimum	Maximum
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