Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBatchRespStatistics, ROOT\CIMV2
Class
| Methods | Properties (26)
| Qualifiers (12)
| Instances (4)
| Namespaces (1)
Samples: VB Script
| C#
| VB.Net
| Search on:Microsoft
Description Counters to track SQL Batch Response times
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBatchRespStatistics properties Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBatchRespStatistics has 26 properties (17 Local , 9 Derived )
Detailed description of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBatchRespStatistics properties Local properties (17) of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBatchRespStatistics class ▲ Batches000000msAnd000001ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 0ms but less than 1ms' DetailLevel 100 DisplayName 'Batches >=000000ms & <000001ms' DisplayName009 'Batches >=000000ms & <000001ms' HelpIndex 0 PerfDefault True PerfIndex 0 Batches000000msAnd000001ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches000001msAnd000002ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 1ms but less than 2ms' DetailLevel 100 DisplayName 'Batches >=000001ms & <000002ms' DisplayName009 'Batches >=000001ms & <000002ms' HelpIndex 0 PerfIndex 0 Batches000001msAnd000002ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches000002msAnd000005ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 2ms but less than 5ms' DetailLevel 100 DisplayName 'Batches >=000002ms & <000005ms' DisplayName009 'Batches >=000002ms & <000005ms' HelpIndex 0 PerfIndex 0 Batches000002msAnd000005ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches000005msAnd000010ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 5ms but less than 10ms' DetailLevel 100 DisplayName 'Batches >=000005ms & <000010ms' DisplayName009 'Batches >=000005ms & <000010ms' HelpIndex 0 PerfIndex 0 Batches000005msAnd000010ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches000010msAnd000020ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 10ms but less than 20ms' DetailLevel 100 DisplayName 'Batches >=000010ms & <000020ms' DisplayName009 'Batches >=000010ms & <000020ms' HelpIndex 0 PerfIndex 0 Batches000010msAnd000020ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches000020msAnd000050ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 20ms but less than 50ms' DetailLevel 100 DisplayName 'Batches >=000020ms & <000050ms' DisplayName009 'Batches >=000020ms & <000050ms' HelpIndex 0 PerfIndex 0 Batches000020msAnd000050ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches000050msAnd000100ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 50ms but less than 100ms' DetailLevel 100 DisplayName 'Batches >=000050ms & <000100ms' DisplayName009 'Batches >=000050ms & <000100ms' HelpIndex 0 PerfIndex 0 Batches000050msAnd000100ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches000100msAnd000200ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 100ms but less than 200ms' DetailLevel 100 DisplayName 'Batches >=000100ms & <000200ms' DisplayName009 'Batches >=000100ms & <000200ms' HelpIndex 0 PerfIndex 0 Batches000100msAnd000200ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches000200msAnd000500ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 200ms but less than 500ms' DetailLevel 100 DisplayName 'Batches >=000200ms & <000500ms' DisplayName009 'Batches >=000200ms & <000500ms' HelpIndex 0 PerfIndex 0 Batches000200msAnd000500ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches000500msAnd001000ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 500ms but less than 1,000ms' DetailLevel 100 DisplayName 'Batches >=000500ms & <001000ms' DisplayName009 'Batches >=000500ms & <001000ms' HelpIndex 0 PerfIndex 0 Batches000500msAnd001000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches001000msAnd002000ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 1,000ms but less than 2,000ms' DetailLevel 100 DisplayName 'Batches >=001000ms & <002000ms' DisplayName009 'Batches >=001000ms & <002000ms' HelpIndex 0 PerfIndex 0 Batches001000msAnd002000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches002000msAnd005000ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 2,000ms but less than 5,000ms' DetailLevel 100 DisplayName 'Batches >=002000ms & <005000ms' DisplayName009 'Batches >=002000ms & <005000ms' HelpIndex 0 PerfIndex 0 Batches002000msAnd005000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches005000msAnd010000ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 5,000ms but less than 10,000ms' DetailLevel 100 DisplayName 'Batches >=005000ms & <010000ms' DisplayName009 'Batches >=005000ms & <010000ms' HelpIndex 0 PerfIndex 0 Batches005000msAnd010000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches010000msAnd020000ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 10,000ms but less than 20,000ms' DetailLevel 100 DisplayName 'Batches >=010000ms & <020000ms' DisplayName009 'Batches >=010000ms & <020000ms' HelpIndex 0 PerfIndex 0 Batches010000msAnd020000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches020000msAnd050000ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 20,000ms but less than 50,000ms' DetailLevel 100 DisplayName 'Batches >=020000ms & <050000ms' DisplayName009 'Batches >=020000ms & <050000ms' HelpIndex 0 PerfIndex 0 Batches020000msAnd050000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches050000msAnd100000ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 50,000ms but less than 100,000ms' DetailLevel 100 DisplayName 'Batches >=050000ms & <100000ms' DisplayName009 'Batches >=050000ms & <100000ms' HelpIndex 0 PerfIndex 0 Batches050000msAnd100000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
▲ Batches100000ms propertyCIMTYPE 'uint64' CounterType 65792 DefaultScale -3 Description 'Number of SQL Batches having response time greater than or equal to 100,000ms' DetailLevel 100 DisplayName 'Batches >=100000ms' DisplayName009 'Batches >=100000ms' HelpIndex 0 PerfIndex 0 Batches100000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
Derived properties (9) of Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBatchRespStatistics 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 1046 classes of ROOT\cimv2 and in 142 namespaces
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBatchRespStatistics Qualifiers Name Value ToInstance ToSubclass Overridable Amended Local
Description 'Counters to track SQL Batch Response times' ✓ ✗ ✓ ✓ ✓
DetailLevel 100 ✓ ✗ ✓ ✗ ✓
DisplayName 'MSSQL$MICROSOFT##WID:Batch Resp Statistics' ✓ ✗ ✓ ✓ ✓
DisplayName009 'MSSQL$MICROSOFT##WID:Batch Resp Statistics' ✓ ✗ ✓ ✗ ✓
dynamic True ✓ ✗ ✓ ✗ ✓
GenericPerfCtr True ✓ ✗ ✓ ✗ ✓
HelpIndex 0 ✓ ✗ ✓ ✗ ✓
HiPerf True ✓ ✗ ✓ ✗ ✓
Locale 1033 ✓ ✗ ✓ ✓ ✓
PerfIndex 0 ✓ ✗ ✓ ✗ ✓
provider 'WmiPerfInst' ✗ ✗ ✓ ✗ ✓
RegistryKey 'MSSQL$MICROSOFT##WID' ✓ ✗ ✓ ✗ ✓
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBatchRespStatistics System properties Similar Classes to Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDBatchRespStatistics Number of classes:1
Please enable JavaScript to view the comments powered by Disqus.
comments powered by