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)

NameOriginCIMType
BusyworkersthrottlingWin32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
DatareadIOdelaythrottlingWin32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly21 [uint64]
DataspacethrottlingWin32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
LogspacethrottlingWin32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly21 [uint64]
LogwriteIOdelaythrottlingWin32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly21 [uint64]
key
Name
CIM_StatisticalInformation8 [string]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [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'
CounterType65792
Description'Number of partitions affected by hard throttling due to busy workers threshold'
DisplayName'Busy workers throttling'
DisplayName009'Busy workers throttling'
HelpIndex0
PerfIndex0
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'
CounterType65792
Description'Number of partitions affected by hard data read IO delay throttling'
DisplayName'Data read IO delay throttling'
DisplayName009'Data read IO delay throttling'
HelpIndex0
PerfIndex0
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'
CounterType65792
Description'Number of partitions affected by hard data space throttling'
DisplayName'Data space throttling'
DisplayName009'Data space throttling'
HelpIndex0
PerfIndex0
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'
CounterType65792
Description'Number of partitions affected by hard log space throttling'
DisplayName'Log space throttling'
DisplayName009'Log space throttling'
HelpIndex0
PerfIndex0
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'
CounterType65792
Description'Number of partitions affected by hard log write IO delay throttling'
DisplayName'Log write IO delay throttling'
DisplayName009'Log write IO delay throttling'
HelpIndex0
PerfIndex0
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.'
MaxLen64
readTrue
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.'
readTrue
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. '
keyTrue
MaxLen256
readTrue
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

NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1
AutoCook_RawClass'Win32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly'
CookedTrue
Description'Counters to track rate of partitions affected by hard throttling incidents'
DisplayName'SQLServer:Throttl Hard Partition'
DisplayName009'SQLServer:Throttl Hard Partition'
dynamicTrue
GenericPerfCtrTrue
HelpIndex0
HiPerfTrue
Locale1033
PerfIndex0
provider'WmiPerfInst'
RegistryKey'MSSQLSERVER'

Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly System properties

NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly'___SYSTEM8
__NAMESPACE'ROOT\cimv2'___SYSTEM8
__SERVER'.'___SYSTEM8
__DERIVATION['Win32_PerfFormattedData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8
__PROPERTY_COUNT14___SYSTEM3
__RELPATH'Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly'___SYSTEM8
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8
__SUPERCLASS'Win32_PerfFormattedData'___SYSTEM8
__CLASS'Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly'___SYSTEM8
__GENUS1___SYSTEM3
comments powered by Disqus
WUtils.com