S.NO | Performance Counter Name | Comments |
1 | SQLServer:Access Methods – Full Scans / sec | Value greater than 1 or 2 indicates that we are having table / Index page scans. We need to analyze how this can be avoided. |
2 | SQLServer:Access Methods – Page Splits/sec | Interesting counter that can lead us to our table / index design. This value needs to be low as possible. |
3 | SQLServer:Access Methods – Table Lock Escalations/sec | This gives us the number of times a table lock was asked for in a second. A high number needs a revisit to the query and the indexes on the table. |
Home » Performance Tuning » Other Important Performance Counters »