SQL Server SQL Statistics Counters

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.

Leave a Reply

Your email address will not be published. Required fields are marked *