SQL Server, Latches Object

 

Applies To: SQL Server 2016

The SQLServer:Latches object in Microsoft SQL Server provides counters to monitor internal SQL Server resource locks called latches. Monitoring the latches to determine user activity and resource usage can help you to identify performance bottlenecks.

This table describes the SQL Server Latches counters.

SQL Server Latches countersDescription
Average Latch Wait Time (ms)Average latch wait time (in milliseconds) for latch requests that had to wait.
Average Latch Wait Time BaseFor internal use only.
Latch Waits/secNumber of latch requests that could not be granted immediately.
Number of SuperLatchesNumber of latches that are currently SuperLatches.
SuperLatch Demotions/secNumber of SuperLatches that have been demoted to regular latches in the last second.
SuperLatch Promotions/secNumber of latches that have been promoted to SuperLatches in the last second.
Total Latch Wait Time (ms)Total latch wait time (in milliseconds) for latch requests in the last second.

Monitor Resource Usage (System Monitor)

Community Additions

ADD
Show: