Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly, ROOT\CIMV2
Methods | Properties (14)
| Qualifiers (14)
| Instances | Namespaces (1)
Samples: VB Script
| C#
| VB.Net
| Search on:Microsoft
Description Counters to track rate of partitions affected by hard throttling incidents
Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly properties Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly has 14 properties (local , Derived )
Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly properties Local properties (5) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly class ▲ Busyworkersthrottling propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'Busyworkersthrottling' CounterType 65792 Description 'Number of partitions affected by hard throttling due to busy workers threshold' DisplayName 'Busy workers throttling' DisplayName009 'Busy workers throttling' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' Busyworkersthrottling property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ DatareadIOdelaythrottling propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'DatareadIOdelaythrottling' CounterType 65792 Description 'Number of partitions affected by hard data read IO delay throttling' DisplayName 'Data read IO delay throttling' DisplayName009 'Data read IO delay throttling' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' DatareadIOdelaythrottling property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ Dataspacethrottling propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'Dataspacethrottling' CounterType 65792 Description 'Number of partitions affected by hard data space throttling' DisplayName 'Data space throttling' DisplayName009 'Data space throttling' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' Dataspacethrottling property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ Logspacethrottling propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'Logspacethrottling' CounterType 65792 Description 'Number of partitions affected by hard log space throttling' DisplayName 'Log space throttling' DisplayName009 'Log space throttling' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' Logspacethrottling property is in 2 classes of ROOT\cimv2 and in 1 namespace
▲ LogwriteIOdelaythrottling propertyCIMTYPE 'uint64' CookingType 'PERF_COUNTER_LARGE_RAWCOUNT' Counter 'LogwriteIOdelaythrottling' CounterType 65792 Description 'Number of partitions affected by hard log write IO delay throttling' DisplayName 'Log write IO delay throttling' DisplayName009 'Log write IO delay throttling' HelpIndex 0 PerfIndex 0 PerfTimeFreq 'Frequency_PerfTime' PerfTimeStamp 'Timestamp_PerfTime' LogwriteIOdelaythrottling property is in 2 classes of ROOT\cimv2 and in 1 namespace
Derived properties (9) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly 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. ' key True MaxLen 256 read True Name property is in 1030 classes of ROOT\cimv2 and in 142 namespaces
Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly Qualifiers Name Value ToInstance ToSubclass Overridable Amended Local
AutoCook 1 ✓ ✗ ✓ ✗ ✓
AutoCook_RawClass 'Win32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly' ✓ ✗ ✓ ✗ ✓
Cooked True ✓ ✗ ✓ ✗ ✓
Description 'Counters to track rate of partitions affected by hard throttling incidents' ✓ ✗ ✓ ✓ ✓
DisplayName 'SQLServer:Throttl Hard Partition' ✓ ✗ ✓ ✓ ✓
DisplayName009 'SQLServer:Throttl Hard Partition' ✓ ✗ ✓ ✗ ✓
dynamic True ✓ ✗ ✓ ✗ ✓
GenericPerfCtr True ✓ ✗ ✓ ✗ ✓
HelpIndex 0 ✓ ✗ ✓ ✗ ✓
HiPerf True ✓ ✗ ✓ ✗ ✓
Locale 1033 ✓ ✗ ✓ ✓ ✓
PerfIndex 0 ✓ ✗ ✓ ✗ ✓
provider 'WmiPerfInst' ✗ ✗ ✓ ✗ ✓
RegistryKey 'MSSQLSERVER' ✓ ✗ ✓ ✗ ✓
Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly System properties
Please enable JavaScript to view the comments powered by Disqus.
comments powered by