Locks and Latches

The Locks and Latches window shows information about the locks and latches (internal SQL Server resource locks). 
It is splitted in two parts:

1. Latches

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.

2. Locks

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.

See also:

Go back to the Learning center:

Copyright © AgileLoad. All rights reserved.
Agile Load testing tool| Contact AgileLoad | Terms of Use | Sitemap