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. |
Home » Performance Tuning »