| S.NO | Performance Counter Name | Comments |
| 1 | SQL Server:SQL Statistics – Batch Requests/Sec | “Number of batch requests received per second, and is a good general indicator for the activity level of the SQL Server. This counter is highly dependent on the hardware and quality of code running on the server. The more powerful the hardware, the higher this number can be, even on poorly coded applications. A value of 1000 batch requests/sec is easily attainable though a typical 100Mbs NIC can only handle about 3000 batch requests/sec.” |
| 2 | SQL Server:SQL Statistics – SQL Compilations/sec | The number of times per second that SQL Server compilations have occurred. This value needs to be as low as possible. |
| 3 | SQL Server:SQL Statistics – SQL Re-Compilations/sec | This needs to be nil in our system as much as possible. A recompile can cause deadlocks and compile locks that are not compatible with any locking type. |
Home » Performance Tuning » Other Important Performance Counters »