N-central Help

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.