Locks and Latches
The Locks and Latches window shows
information about the locks and latches (internal SQL Server
It is splitted in two parts:
Total Latch wait time (ms)
Total latch wait time (in milliseconds) for latch requests in the last second.
Latch Waits per second
Number of latch requests that could not be granted immediately.
The Locks grid shows each individual locks type
Database Database Extent Contiguous group of eight data pages or index pages. Key Row lock within an index. Page 8-kilobyte (KB) data page or index page. RID Row ID. Used to lock a single row within a table. Table Entire table, including all data and indexes.
with the followings counters:
Wait Time (ms)
Average Average amount of wait time (in milliseconds) for each lock request that resulted in a wait. Wait Time Total wait time (in milliseconds) for locks in the last second.
Locks per second
Requests Number of new locks and lock conversions per second requested from the lock manager. Timeouts Number of lock requests per second that timed out, including internal requests for NOWAIT locks. Waits Number of lock requests per second that required the caller to wait. Deadlocks Number of lock requests per second that resulted in a deadlock.
By default, the last snapshot is displayed in the grid. Use the slidder (or the arrow buttons) located at the top of the grid to navigate through the collected snapshots. In monitoring, the "Auto Update" button must be unchecked to be able to navigate through the collected snapshots.
Select one or more locks types in the grid (Check box at the left of the grid) to update the graphes located at the bottom of the window. If several entries are selected, the statistics are aggregated.
Copyright © AgileLoad. All rights reserved.