WUtils.com

Win32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly, ROOT\CIMV2

Class | Methods | Properties (14) | Qualifiers (13) | 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_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly properties

Win32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly has 14 properties (5 Local, 9 Derived)

NameOriginCIMType
BusyworkersthrottlingWin32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
DatareadIOdelaythrottlingWin32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly21 [uint64]
DataspacethrottlingWin32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
LogspacethrottlingWin32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly21 [uint64]
LogwriteIOdelaythrottlingWin32_PerfRawData_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_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly properties

Local properties (5) of Win32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly class

…
▲ Busyworkersthrottling property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of partitions affected by hard throttling due to busy workers threshold'
DetailLevel100
DisplayName'Busy workers throttling'
DisplayName009'Busy workers throttling'
HelpIndex0
PerfIndex0
Busyworkersthrottling property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ DatareadIOdelaythrottling property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of partitions affected by hard data read IO delay throttling'
DetailLevel100
DisplayName'Data read IO delay throttling'
DisplayName009'Data read IO delay throttling'
HelpIndex0
PerfIndex0
DatareadIOdelaythrottling property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Dataspacethrottling property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of partitions affected by hard data space throttling'
DetailLevel100
DisplayName'Data space throttling'
DisplayName009'Data space throttling'
HelpIndex0
PerfIndex0
Dataspacethrottling property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Logspacethrottling property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of partitions affected by hard log space throttling'
DetailLevel100
DisplayName'Log space throttling'
DisplayName009'Log space throttling'
HelpIndex0
PerfDefaultTrue
PerfIndex0
Logspacethrottling property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogwriteIOdelaythrottling property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of partitions affected by hard log write IO delay throttling'
DetailLevel100
DisplayName'Log write IO delay throttling'
DisplayName009'Log write IO delay throttling'
HelpIndex0
PerfIndex0
LogwriteIOdelaythrottling property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_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 1050 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 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. '
keyTrue
MaxLen256
readTrue
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_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
CostlyTrue✓✗✓✗✓
Description'Counters to track rate of partitions affected by hard throttling incidents'✓✗✓✓✓
DetailLevel100✓✗✓✗✓
DisplayName'SQLServer:Throttl Hard Partition'✓✗✓✓✓
DisplayName009'SQLServer:Throttl Hard Partition'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓

Win32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly System properties

…
NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly'___SYSTEM8✗✗
__NAMESPACE'ROOT\cimv2'___SYSTEM8✗✗
__SERVER'.'___SYSTEM8✗✗
__DERIVATION['Win32_PerfRawData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8✗✓
__PROPERTY_COUNT14___SYSTEM3✗✗
__RELPATH'Win32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly'___SYSTEM8✗✗
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8✗✗
__SUPERCLASS'Win32_PerfRawData'___SYSTEM8✗✗
__CLASS'Win32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly'___SYSTEM8✗✗
__GENUS1___SYSTEM3✗✗

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly

Number of classes:37
…
Class nameChildsPropertiesMethodsClass
Instances		Child
Instances		AbstractSingleton
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDCloudDBMessaging_Costly01301--✓
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDCloudDBReplication_Costly01701--✓
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTCMAgents_Costly01901--✓
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTraceEventStatistics_Costly0140----
Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTraceStatistics_Costly0130----
Win32_PerfFormattedData_MSSQLSERVER_SQLServerCloudDBMessaging_Costly01301--✓
Win32_PerfFormattedData_MSSQLSERVER_SQLServerCloudDBReplication_Costly01701--✓
Win32_PerfFormattedData_MSSQLSERVER_SQLServerTCMAgents_Costly01901--✓
Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlHardPartition_Costly0140----
Win32_PerfFormattedData_MSSQLSERVER_SQLServerThrottlSoftPartition_Costly0140----
Win32_PerfFormattedData_MSSQLSERVER_SQLServerTraceEventStatistics_Costly0140----
Win32_PerfFormattedData_MSSQLSERVER_SQLServerTraceStatistics_Costly0130----
Win32_PerfFormattedData_PerfProc_FullImage_Costly017040---
Win32_PerfFormattedData_PerfProc_Heap_Costly03303---
Win32_PerfFormattedData_PerfProc_Image_Costly017040---
Win32_PerfFormattedData_PerfProc_ProcessAddressSpace_Costly046040---
Win32_PerfFormattedData_PerfProc_ThreadDetails_Costly010040---
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDCloudDBMessaging_Costly01301--✓
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDCloudDBReplication_Costly01701--✓
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTCMAgents_Costly02401--✓
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTraceEventStatistics_Costly0140----
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDTraceStatistics_Costly0130----
Win32_PerfRawData_MSSQLSERVER_SQLServerCloudDBMessaging_Costly01301--✓
Win32_PerfRawData_MSSQLSERVER_SQLServerCloudDBReplication_Costly01701--✓
Win32_PerfRawData_MSSQLSERVER_SQLServerTCMAgents_Costly02401--✓
Win32_PerfRawData_MSSQLSERVER_SQLServerThrottlSoftPartition_Costly0140----
Win32_PerfRawData_MSSQLSERVER_SQLServerTraceEventStatistics_Costly0140----
Win32_PerfRawData_MSSQLSERVER_SQLServerTraceStatistics_Costly0130----
Win32_PerfRawData_PerfProc_FullImage_Costly017040---
Win32_PerfRawData_PerfProc_Heap_Costly03303---
Win32_PerfRawData_PerfProc_Image_Costly017040---
Win32_PerfRawData_PerfProc_ProcessAddressSpace_Costly046040---
Win32_PerfRawData_PerfProc_ThreadDetails_Costly010040---
comments powered by Disqus
WUtils.com