Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SQL Server, Latches Object

SQL Server, Latches Object

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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 counters

Description

Average Latch Wait Time (ms)

Average latch wait time (in milliseconds) for latch requests that had to wait.

Latch Waits/sec

Number of latch requests that could not be granted immediately.

Number of SuperLatches

Number of latches that are currently SuperLatches.

SuperLatch Demotions/sec

Number of SuperLatches that have been demoted to regular latches in the last second.

SuperLatch Promotions/sec

Number 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.

Community Additions

ADD
Show:
© 2015 Microsoft