Home » Performance Tuning » Other Important Performance Counters » User Database Performance Counters

User Database Performance Counters

S.NO Performance Counter Name Comments
1 SQL Server:Databases – Active Transactions The number of currently active transactions in the system.
2 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.
3 SQL Server:Databases – Transactions/sec This number indicates how active our SQL Server system is. A higher value indicates more activity is occurring.
4 SQL Server:General Statistics – User Connections The number of users currently connected to the SQL Server.

Leave a Reply

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