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)

Name	Origin	CIMType
Busyworkersthrottling	Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly	21 [uint64]
Caption	CIM_StatisticalInformation	8 [string]
DatareadIOdelaythrottling	Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly	21 [uint64]
Dataspacethrottling	Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly	21 [uint64]
Description	CIM_StatisticalInformation	8 [string]
Frequency_Object	Win32_Perf	21 [uint64]
Frequency_PerfTime	Win32_Perf	21 [uint64]
Frequency_Sys100NS	Win32_Perf	21 [uint64]
Logspacethrottling	Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly	21 [uint64]
LogwriteIOdelaythrottling	Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly	21 [uint64]
key Name	CIM_StatisticalInformation	8 [string]
Timestamp_Object	Win32_Perf	21 [uint64]
Timestamp_PerfTime	Win32_Perf	21 [uint64]
Timestamp_Sys100NS	Win32_Perf	21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly properties

Local properties (5) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly class

▲ Busyworkersthrottling property
CIMTYPE	'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 property
CIMTYPE	'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 property
CIMTYPE	'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 property
CIMTYPE	'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 property
CIMTYPE	'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

▲ 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 1034 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 1045 classes of ROOT\cimv2 and in 142 namespaces

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

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

▲ Frequency_Sys100NS property
CIMTYPE	'uint64'
Frequency_Sys100NS property is in 711 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. '
key	True
MaxLen	256
read	True
Name property is in 1030 classes of ROOT\cimv2 and in 142 namespaces

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

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

▲ Timestamp_Sys100NS property
CIMTYPE	'uint64'
Timestamp_Sys100NS property is in 711 classes of ROOT\cimv2 and in 2 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

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

comments powered by Disqus