Users & Locks Performance Counters

Performance Counter Name Comments
1 SQL Server:General Statistics – User Connections The number of users currently connected to the SQL Server.
2 SQL Server:Locks – Lock Requests/sec Number of requests for a type of lock per second.
3 SQL Server:Locks – Average Wait Time This is the average wait time in milliseconds to acquire a lock. Lower the value the better it is.
4 SQL Server:Locks – Number of Deadlocks/sec The number of lock requests that resulted in a deadlock.

Leave a Reply

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