Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLatches, 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_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLatches properties Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLatches has 15 properties (6 Local , 9 Derived )
Detailed description of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLatches properties Local properties (6) of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLatches class ▲ AverageLatchWaitTimems propertyCIMTYPE '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 propertyCIMTYPE '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 propertyCIMTYPE '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 propertyCIMTYPE '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 propertyCIMTYPE '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 propertyCIMTYPE '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_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLatches class
▲ Name propertyCIMTYPE '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
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLatches Qualifiers Name Value ToInstance ToSubclass Overridable Amended Local
AutoCook 1 ✓ ✗ ✓ ✗ ✓
AutoCook_RawClass 'Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLatches' ✓ ✗ ✓ ✗ ✓
Cooked True ✓ ✗ ✓ ✗ ✓
Description 'Collects statistics associated with internal server latches' ✓ ✗ ✓ ✓ ✓
DisplayName 'MSSQL$MICROSOFT##WID:Latches' ✓ ✗ ✓ ✓ ✓
DisplayName009 'MSSQL$MICROSOFT##WID:Latches' ✓ ✗ ✓ ✗ ✓
dynamic True ✓ ✗ ✓ ✗ ✓
GenericPerfCtr True ✓ ✗ ✓ ✗ ✓
HelpIndex 0 ✓ ✗ ✓ ✗ ✓
HiPerf True ✓ ✗ ✓ ✗ ✓
Locale 1033 ✓ ✗ ✓ ✓ ✓
PerfIndex 0 ✓ ✗ ✓ ✗ ✓
provider 'WmiPerfInst' ✗ ✗ ✓ ✗ ✓
RegistryKey 'MSSQL$MICROSOFT##WID' ✓ ✗ ✓ ✗ ✓
Singleton True ✓ ✓ ✗ ✗ ✓
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLatches System properties Similar Classes to Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDLatches Number of classes:1
Please enable JavaScript to view the comments powered by Disqus.
comments powered by