WUtils.com

Win32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics, 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_MSSQLSERVER_SQLServerBatchRespStatistics properties

Win32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics has 26 properties (17 Local, 9 Derived)

NameOriginCIMType
Batches000000msAnd000001msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches000001msAnd000002msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches000002msAnd000005msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches000005msAnd000010msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches000010msAnd000020msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches000020msAnd000050msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches000050msAnd000100msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches000100msAnd000200msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches000200msAnd000500msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches000500msAnd001000msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches001000msAnd002000msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches002000msAnd005000msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches005000msAnd010000msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches010000msAnd020000msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches020000msAnd050000msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches050000msAnd100000msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
Batches100000msWin32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
key
Name		CIM_StatisticalInformation8 [string]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics properties

Local properties (17) of Win32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics class

…
▲ Batches000000msAnd000001ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 0ms but less than 1ms'
DetailLevel100
DisplayName'Batches >=000000ms & <000001ms'
DisplayName009'Batches >=000000ms & <000001ms'
HelpIndex0
PerfDefaultTrue
PerfIndex0
Batches000000msAnd000001ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches000001msAnd000002ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 1ms but less than 2ms'
DetailLevel100
DisplayName'Batches >=000001ms & <000002ms'
DisplayName009'Batches >=000001ms & <000002ms'
HelpIndex0
PerfIndex0
Batches000001msAnd000002ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches000002msAnd000005ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 2ms but less than 5ms'
DetailLevel100
DisplayName'Batches >=000002ms & <000005ms'
DisplayName009'Batches >=000002ms & <000005ms'
HelpIndex0
PerfIndex0
Batches000002msAnd000005ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches000005msAnd000010ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 5ms but less than 10ms'
DetailLevel100
DisplayName'Batches >=000005ms & <000010ms'
DisplayName009'Batches >=000005ms & <000010ms'
HelpIndex0
PerfIndex0
Batches000005msAnd000010ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches000010msAnd000020ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 10ms but less than 20ms'
DetailLevel100
DisplayName'Batches >=000010ms & <000020ms'
DisplayName009'Batches >=000010ms & <000020ms'
HelpIndex0
PerfIndex0
Batches000010msAnd000020ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches000020msAnd000050ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 20ms but less than 50ms'
DetailLevel100
DisplayName'Batches >=000020ms & <000050ms'
DisplayName009'Batches >=000020ms & <000050ms'
HelpIndex0
PerfIndex0
Batches000020msAnd000050ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches000050msAnd000100ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 50ms but less than 100ms'
DetailLevel100
DisplayName'Batches >=000050ms & <000100ms'
DisplayName009'Batches >=000050ms & <000100ms'
HelpIndex0
PerfIndex0
Batches000050msAnd000100ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches000100msAnd000200ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 100ms but less than 200ms'
DetailLevel100
DisplayName'Batches >=000100ms & <000200ms'
DisplayName009'Batches >=000100ms & <000200ms'
HelpIndex0
PerfIndex0
Batches000100msAnd000200ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches000200msAnd000500ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 200ms but less than 500ms'
DetailLevel100
DisplayName'Batches >=000200ms & <000500ms'
DisplayName009'Batches >=000200ms & <000500ms'
HelpIndex0
PerfIndex0
Batches000200msAnd000500ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches000500msAnd001000ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 500ms but less than 1,000ms'
DetailLevel100
DisplayName'Batches >=000500ms & <001000ms'
DisplayName009'Batches >=000500ms & <001000ms'
HelpIndex0
PerfIndex0
Batches000500msAnd001000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches001000msAnd002000ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 1,000ms but less than 2,000ms'
DetailLevel100
DisplayName'Batches >=001000ms & <002000ms'
DisplayName009'Batches >=001000ms & <002000ms'
HelpIndex0
PerfIndex0
Batches001000msAnd002000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches002000msAnd005000ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 2,000ms but less than 5,000ms'
DetailLevel100
DisplayName'Batches >=002000ms & <005000ms'
DisplayName009'Batches >=002000ms & <005000ms'
HelpIndex0
PerfIndex0
Batches002000msAnd005000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches005000msAnd010000ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 5,000ms but less than 10,000ms'
DetailLevel100
DisplayName'Batches >=005000ms & <010000ms'
DisplayName009'Batches >=005000ms & <010000ms'
HelpIndex0
PerfIndex0
Batches005000msAnd010000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches010000msAnd020000ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 10,000ms but less than 20,000ms'
DetailLevel100
DisplayName'Batches >=010000ms & <020000ms'
DisplayName009'Batches >=010000ms & <020000ms'
HelpIndex0
PerfIndex0
Batches010000msAnd020000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches020000msAnd050000ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 20,000ms but less than 50,000ms'
DetailLevel100
DisplayName'Batches >=020000ms & <050000ms'
DisplayName009'Batches >=020000ms & <050000ms'
HelpIndex0
PerfIndex0
Batches020000msAnd050000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches050000msAnd100000ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 50,000ms but less than 100,000ms'
DetailLevel100
DisplayName'Batches >=050000ms & <100000ms'
DisplayName009'Batches >=050000ms & <100000ms'
HelpIndex0
PerfIndex0
Batches050000msAnd100000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Batches100000ms property
CIMTYPE'uint64'
CounterType65792
DefaultScale-3
Description'Number of SQL Batches having response time greater than or equal to 100,000ms'
DetailLevel100
DisplayName'Batches >=100000ms'
DisplayName009'Batches >=100000ms'
HelpIndex0
PerfIndex0
Batches100000ms property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics 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_SQLServerBatchRespStatistics Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
Description'Counters to track SQL Batch Response times'✓✗✓✓✓
DetailLevel100✓✗✓✗✓
DisplayName'SQLServer:Batch Resp Statistics'✓✗✓✓✓
DisplayName009'SQLServer:Batch Resp Statistics'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓

Win32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics System properties

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

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerBatchRespStatistics

Number of classes:1
…
Class nameChildsPropertiesMethodsClass
Instances		Child
Instances		AbstractSingleton
Win32_PerfFormattedData_MSSQLSERVER_SQLServerBatchRespStatistics02604---
comments powered by Disqus
WUtils.com