SQL Server Locks service
The SQL Server Locks service monitors how an SQL Server manages locks on individual resource types. Locks are maintained on SQL Server resources to prevent concurrent use of the resources by different transactions. For example, rows read or modified during a transaction.
| Service Type | WMI |
| Instances on a Device | 15 |
| Supported Systems/Applications | Microsoft SQL Server |
| Device Class | Server - Generic, Workstation - Generic, Other, Printer, Scanner/Camera, Switch/Router, Laptop - Windows, Server - Windows, and Workstation - Windows |
| Monitored By | Windows agent |
| Scan Interval | 15 minutes |
| SQL Server Instance | The specific instance of the SQL Server database engine running on the target server. |
| Resource Name | The name of the lock resource to obtain statistics. |
| Status Detail | Description |
|---|---|
| Lock Waits per Second | The number of lock requests per second that required originators to wait. |
| Average Wait Time in Milliseconds | The average amount of wait time for each lock request that resulted in a wait. |
| Lock Timeouts per Second | The number of lock requests per second that timed out, including requests for NOWAIT locks. |
| Number of Deadlocks per Second | The number of lock requests per second that resulted in a deadlock. |