SQL Server: Locks

3 4

This object contains a number of counters that keep track of lock activity. Each counter monitors activities related to the following SQL Server lock types: database locks, extent locks, key locks, page locks, RID locks (row locks), and table locks. These counters show you the types of locks that are being used in your system and how often these locks are used. The counters are as follows:

• Average Wait Time (ms) Average time, in milliseconds, that a thread is waiting for the specified type of lock.
• Lock Requests/sec Number of requests per second for the specified type of lock.
• Lock Timeouts/sec Number of times per second that a lock could not be obtained by spinning. The setting of the SQL Server configuration parameter spin counter governs the number of times that a thread spins before timing out and sleeping.
• Lock Wait Time (ms) Total wait time for locks, in milliseconds, for the last second.
• Lock Waits/sec Number of times a lock request caused a thread to wait in the last second.
• Number of Deadlocks/sec Number of lock requests per second that resulted in a deadlock.