Skip to content

Latest commit

 

History

History
38 lines (33 loc) · 1.78 KB

File metadata and controls

38 lines (33 loc) · 1.78 KB
title SQL Server, Latches Object | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.suite
ms.technology
dbe-cross-instance
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
Latches object
SQLServer:Latches
ms.assetid 2393ea1c-2bf3-41c3-9f37-b9761144eeca
caps.latest.revision 21
author craigg-msft
ms.author craigg
manager jhubbard

SQL Server, Latches Object

The SQLServer:Latches object in Microsoft [!INCLUDEssNoVersion] provides counters to monitor internal [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] 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.

See Also

Monitor Resource Usage (System Monitor)