Listed below are few important Perfmon Counters and threshold values for CPU, Memory,Disk trouble shooting.
| Metric | Object | Counter | Threshold value |
| CPU | Process (sqlservr) | %Processor Time | < 80% |
| System | Processor Queue Length | < 4 per CPU | |
| Memory | Memory | Available Mbytes | > 100MB |
| SQL Server: Buffer Manager | Lazy Writes/Sec | < 20 | |
| SQL Server: Buffer Manager | Page Life Expectancy (PLE) | > 300 | |
| SQL Server: Buffer Manager | Page Lookups/sec | <100 | |
| SQL Server: Buffer Manager | Page Reads/sec | <90 | |
| SQL Server: Buffer Manager | Readahead/sec | < 20% of page Reads/sec | |
| SQL Server: Buffer Manager | Buffer Cache Hit Ratio | >99 % | |
| Disk | Physical Disk | Avg. Disk Sec/Read | < 8ms |
| PhysicalDisk | Avg. Disk sec/Write | < 8ms | |
| Index | SQLServer:Access Methods | Full Scans / sec | 1 Full Scan/sec per 1000 Index Searches/sec |
| SQLServer:SQL Statistics | SQL Compilations/sec | < 10% of the number of the Batch Requests/sec | |
| SQLServer:SQL Statistics | SQL Re-Compilations/sec | < 10% of the number of SQL compilations/sec |
selectstarfromyogi 