Performance Counters - 2

Performance counters for monitoring SQL Server

Counter Name


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.

SQL Server:Cache Manager - Cache hit ratio

The ratio between the cache hits and misses. This counter is a good indicator of our caching mechanism in SQL Server. This value needs to be high in the system

SQL Server:Databases - Transactions/sec

This number indicates how active our SQL Server system is. A higher value indicates more activity is occurring

SQL Server:Databases - Log growths

The number of times the log files have been extended. If there is lot of activity in this counter we need to allocate static and large enough space for our log files.

SQL Server:General Statistics - User Connections

The number of users currently connected to the SQL Server.


Vinay Jagtap

A hard core Technocrat with over a decade of extensive experience in heading complex test projects coupled with real time experience of project management and thought leadership. Extensive experience in Performance, Security and Automation Testing and development of automation frameworks and ability to setup and execute Global service centers and Center of Excellences for testing.

Get Free Email Updates to your Inbox!

Powered by Blogger.


Total Pageviews

Copyright © T R I A G E D T E S T E R