Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches, ROOT\CIMV2

Class | Methods | Properties (15) | Qualifiers (15) | Instances (1) | Namespaces (1)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

Description

Collects statistics associated with internal server latches

Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches properties

Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches has 15 properties (6 Local, 9 Derived)

Name	Origin	CIMType
AverageLatchWaitTimems	Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches	21 [uint64]
Caption	CIM_StatisticalInformation	8 [string]
Description	CIM_StatisticalInformation	8 [string]
Frequency_Object	Win32_Perf	21 [uint64]
Frequency_PerfTime	Win32_Perf	21 [uint64]
Frequency_Sys100NS	Win32_Perf	21 [uint64]
LatchWaitsPersec	Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches	21 [uint64]
Name	CIM_StatisticalInformation	8 [string]
NumberofSuperLatches	Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches	21 [uint64]
SuperLatchDemotionsPersec	Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches	21 [uint64]
SuperLatchPromotionsPersec	Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches	21 [uint64]
Timestamp_Object	Win32_Perf	21 [uint64]
Timestamp_PerfTime	Win32_Perf	21 [uint64]
Timestamp_Sys100NS	Win32_Perf	21 [uint64]
TotalLatchWaitTimems	Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches	21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches properties

Local properties (6) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches class

▲ AverageLatchWaitTimems property
CIMTYPE	'uint64'
CookingType	'PERF_AVERAGE_BULK'
Counter	'AverageLatchWaitTimems'
CounterType	1073874176
Description	'Average latch wait time (milliseconds) for latch requests that had to wait.'
DisplayName	'Average Latch Wait Time (ms)'
DisplayName009	'Average Latch Wait Time (ms)'
HelpIndex	0
PerfIndex	0
PerfTimeFreq	'Frequency_PerfTime'
PerfTimeStamp	'Timestamp_PerfTime'
AverageLatchWaitTimems property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ LatchWaitsPersec property
CIMTYPE	'uint64'
CookingType	'PERF_COUNTER_BULK_COUNT'
Counter	'LatchWaitsPersec'
CounterType	272696576
Description	'Number of latch requests that could not be granted immediately and had to wait before being granted.'
DisplayName	'Latch Waits/sec'
DisplayName009	'Latch Waits/sec'
HelpIndex	0
PerfIndex	0
PerfTimeFreq	'Frequency_PerfTime'
PerfTimeStamp	'Timestamp_PerfTime'
LatchWaitsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ NumberofSuperLatches property
CIMTYPE	'uint64'
CookingType	'PERF_COUNTER_LARGE_RAWCOUNT'
Counter	'NumberofSuperLatches'
CounterType	65792
Description	'Number of latches that are currently SuperLatches.'
DisplayName	'Number of SuperLatches'
DisplayName009	'Number of SuperLatches'
HelpIndex	0
PerfIndex	0
PerfTimeFreq	'Frequency_PerfTime'
PerfTimeStamp	'Timestamp_PerfTime'
NumberofSuperLatches property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ SuperLatchDemotionsPersec property
CIMTYPE	'uint64'
CookingType	'PERF_COUNTER_BULK_COUNT'
Counter	'SuperLatchDemotionsPersec'
CounterType	272696576
Description	'Number of SuperLatches that have been demoted to regular latches'
DisplayName	'SuperLatch Demotions/sec'
DisplayName009	'SuperLatch Demotions/sec'
HelpIndex	0
PerfIndex	0
PerfTimeFreq	'Frequency_PerfTime'
PerfTimeStamp	'Timestamp_PerfTime'
SuperLatchDemotionsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ SuperLatchPromotionsPersec property
CIMTYPE	'uint64'
CookingType	'PERF_COUNTER_BULK_COUNT'
Counter	'SuperLatchPromotionsPersec'
CounterType	272696576
Description	'Number of latches that have been promoted to SuperLatches'
DisplayName	'SuperLatch Promotions/sec'
DisplayName009	'SuperLatch Promotions/sec'
HelpIndex	0
PerfIndex	0
PerfTimeFreq	'Frequency_PerfTime'
PerfTimeStamp	'Timestamp_PerfTime'
SuperLatchPromotionsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ TotalLatchWaitTimems property
CIMTYPE	'uint64'
CookingType	'PERF_COUNTER_BULK_COUNT'
Counter	'TotalLatchWaitTimems'
CounterType	272696576
Description	'Total latch wait time (milliseconds) for latch requests that had to wait in the last second.'
DisplayName	'Total Latch Wait Time (ms)'
DisplayName009	'Total Latch Wait Time (ms)'
HelpIndex	0
PerfIndex	0
PerfTimeFreq	'Frequency_PerfTime'
PerfTimeStamp	'Timestamp_PerfTime'
TotalLatchWaitTimems property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches class

▲ Caption property
CIMTYPE	'string'
Description	'A short textual description (one-line string) for the statistic or metric.'
MaxLen	64
read	True
Caption property is in 1050 classes of ROOT\cimv2 and in 37 namespaces

▲ Description property
CIMTYPE	'string'
Description	'A textual description of the statistic or metric.'
read	True
Description property is in 1061 classes of ROOT\cimv2 and in 142 namespaces

▲ Frequency_Object property
CIMTYPE	'uint64'
Frequency_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces

▲ Frequency_PerfTime property
CIMTYPE	'uint64'
Frequency_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces

▲ Frequency_Sys100NS property
CIMTYPE	'uint64'
Frequency_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces

▲ Name property
CIMTYPE	'string'
Description	'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. '
MaxLen	256
read	True
Name property is in 1046 classes of ROOT\cimv2 and in 142 namespaces

▲ Timestamp_Object property
CIMTYPE	'uint64'
Timestamp_Object property is in 727 classes of ROOT\cimv2 and in 2 namespaces

▲ Timestamp_PerfTime property
CIMTYPE	'uint64'
Timestamp_PerfTime property is in 727 classes of ROOT\cimv2 and in 2 namespaces

▲ Timestamp_Sys100NS property
CIMTYPE	'uint64'
Timestamp_Sys100NS property is in 727 classes of ROOT\cimv2 and in 2 namespaces

Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches Qualifiers

Name	Value	ToInstance	ToSubclass	Overridable	Amended	Local
AutoCook	1	✓	✗	✓	✗	✓
AutoCook_RawClass	'Win32_PerfRawData_MSSQLSERVER_SQLServerLatches'	✓	✗	✓	✗	✓
Cooked	True	✓	✗	✓	✗	✓
Description	'Collects statistics associated with internal server latches'	✓	✗	✓	✓	✓
DisplayName	'SQLServer:Latches'	✓	✗	✓	✓	✓
DisplayName009	'SQLServer:Latches'	✓	✗	✓	✗	✓
dynamic	True	✓	✗	✓	✗	✓
GenericPerfCtr	True	✓	✗	✓	✗	✓
HelpIndex	0	✓	✗	✓	✗	✓
HiPerf	True	✓	✗	✓	✗	✓
Locale	1033	✓	✗	✓	✓	✓
PerfIndex	0	✓	✗	✓	✗	✓
provider	'WmiPerfInst'	✗	✗	✓	✗	✓
RegistryKey	'MSSQLSERVER'	✓	✗	✓	✗	✓
Singleton	True	✓	✓	✗	✗	✓

Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches System properties

Name	Value	Origin	CIMType	Local	Array
__PATH	'\\.\ROOT\cimv2:Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches'	___SYSTEM	8	✗	✗
__NAMESPACE	'ROOT\cimv2'	___SYSTEM	8	✗	✗
__SERVER	'.'	___SYSTEM	8	✗	✗
__DERIVATION	['Win32_PerfFormattedData', 'Win32_Perf', 'CIM_StatisticalInformation']	___SYSTEM	8	✗	✓
__PROPERTY_COUNT	15	___SYSTEM	3	✗	✗
__RELPATH	'Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches'	___SYSTEM	8	✗	✗
__DYNASTY	'CIM_StatisticalInformation'	___SYSTEM	8	✗	✗
__SUPERCLASS	'Win32_PerfFormattedData'	___SYSTEM	8	✗	✗
__CLASS	'Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches'	___SYSTEM	8	✗	✗
__GENUS	1	___SYSTEM	3	✗	✗

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerLatches

Number of classes:1

Class name	Childs	Properties	Methods	Class Instances	Child Instances	Abstract	Singleton
Win32_PerfRawData_MSSQLSERVER_SQLServerLatches	0	16	0	1	-	-	✓

comments powered by Disqus