Performance counters for monitoring SQL Server
| Counter Name | Comments |
| 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.
