BACK TO INDEX

Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches
Collects statistics associated with internal server latches
NameSpace Path
\ROOT\CIMV2
PROPERTY	SMS_REPORT	CIMTYPE	DESCRIPTION
AverageLatchWaitTimems		UInt64	Average latch wait time (milliseconds) for latch requests that had to wait.
Caption		String	A short textual description (one-line string) for the statistic or metric.
Description		String	A textual description of the statistic or metric.
Frequency_Object		UInt64	NA
Frequency_PerfTime		UInt64	NA
Frequency_Sys100NS		UInt64	NA
LatchWaitsPersec		UInt64	Number of latch requests that could not be granted immediately and had to wait before being granted.
Name		String	The Name property defines the label by which the statistic or metric is known. When subclassed, the property can be overridden to be a Key property.
NumberofSuperLatches		UInt64	Number of latches that are currently SuperLatches.
SuperLatchDemotionsPersec		UInt64	Number of SuperLatches that have been demoted to regular latches
SuperLatchPromotionsPersec		UInt64	Number of latches that have been promoted to SuperLatches
Timestamp_Object		UInt64	NA
Timestamp_PerfTime		UInt64	NA
Timestamp_Sys100NS		UInt64	NA
TotalLatchWaitTimems		UInt64	Total latch wait time (milliseconds) for latch requests that had to wait in the last second.
SAMPLE DATA INSTANCE
[Description("Collects statistics associated with internal server latches"): ToInstance Amended, DisplayName("SQLServer:Latches"): ToInstance Amended, genericperfctr: ToInstance Amended, locale(1033): ToInstance Amended]    instance of Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches    {     [Description("Average latch wait time (milliseconds) for latch requests that had to wait."): ToInstance Amended, DisplayName("Average Latch Wait Time (ms)"): ToInstance Amended] AverageLatchWaitTimems = "0";     [Description("Number of latch requests that could not be granted immediately and had to wait before being granted."): ToInstance Amended, DisplayName("Latch Waits/sec"): ToInstance Amended] LatchWaitsPersec = "0";     [Description("Number of latches that are currently SuperLatches."): ToInstance Amended, DisplayName("Number of SuperLatches"): ToInstance Amended] NumberofSuperLatches = "0";     [Description("Number of SuperLatches that have been demoted to regular latches"): ToInstance Amended, DisplayName("SuperLatch Demotions/sec"): ToInstance Amended] SuperLatchDemotionsPersec = "0";     [Description("Number of latches that have been promoted to SuperLatches"): ToInstance Amended, DisplayName("SuperLatch Promotions/sec"): ToInstance Amended] SuperLatchPromotionsPersec = "0";     [Description("Total latch wait time (milliseconds) for latch requests that had to wait in the last second."): ToInstance Amended, DisplayName("Total Latch Wait Time (ms)"): ToInstance Amended] TotalLatchWaitTimems = "0";    };