Data Access Performance Counters

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.

Leave a Reply

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