WUtils.com

Win32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics, ROOT\CIMV2

Class | Methods | Properties (21) | Qualifiers (12) | Instances (4) | Namespaces (1)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

Description

Wait Statistics

Win32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics properties

Win32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics has 21 properties (12 Local, 9 Derived)

NameOriginCIMType
CaptionCIM_StatisticalInformation8 [string]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
LockwaitsWin32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
LogbufferwaitsWin32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
LogwritewaitsWin32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
MemorygrantqueuewaitsWin32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
key
Name		CIM_StatisticalInformation8 [string]
NetworkIOwaitsWin32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
NonPagelatchwaitsWin32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
PageIOlatchwaitsWin32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
PagelatchwaitsWin32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
ThreadsafememoryobjectswaitsWin32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
TransactionownershipwaitsWin32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
WaitfortheworkerWin32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
WorkspacesynchronizationwaitsWin32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics properties

Local properties (12) of Win32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics class

…
▲ Lockwaits property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Statistics for processes waiting on a lock.'
DetailLevel100
DisplayName'Lock waits'
DisplayName009'Lock waits'
HelpIndex0
PerfDefaultTrue
PerfIndex0
Lockwaits property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Logbufferwaits property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Statistics for processes waiting for log buffer to be available.'
DetailLevel100
DisplayName'Log buffer waits'
DisplayName009'Log buffer waits'
HelpIndex0
PerfIndex0
Logbufferwaits property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Logwritewaits property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Statistics for processes waiting for log buffer to be written.'
DetailLevel100
DisplayName'Log write waits'
DisplayName009'Log write waits'
HelpIndex0
PerfIndex0
Logwritewaits property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Memorygrantqueuewaits property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Statistics for processes waiting for memory grant to become available.'
DetailLevel100
DisplayName'Memory grant queue waits'
DisplayName009'Memory grant queue waits'
HelpIndex0
PerfIndex0
Memorygrantqueuewaits property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ NetworkIOwaits property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Statistics relevant to wait on network IO.'
DetailLevel100
DisplayName'Network IO waits'
DisplayName009'Network IO waits'
HelpIndex0
PerfIndex0
NetworkIOwaits property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ NonPagelatchwaits property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Statistics relevant to non-page latches.'
DetailLevel100
DisplayName'Non-Page latch waits'
DisplayName009'Non-Page latch waits'
HelpIndex0
PerfIndex0
NonPagelatchwaits property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ PageIOlatchwaits property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Statistics relevant to page IO latches.'
DetailLevel100
DisplayName'Page IO latch waits'
DisplayName009'Page IO latch waits'
HelpIndex0
PerfIndex0
PageIOlatchwaits property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Pagelatchwaits property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Statistics relevant to page latches, not including IO latches'
DetailLevel100
DisplayName'Page latch waits'
DisplayName009'Page latch waits'
HelpIndex0
PerfIndex0
Pagelatchwaits property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Threadsafememoryobjectswaits property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Statistics for processes waiting on thread-safe memory allocators.'
DetailLevel100
DisplayName'Thread-safe memory objects waits'
DisplayName009'Thread-safe memory objects waits'
HelpIndex0
PerfIndex0
Threadsafememoryobjectswaits property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Transactionownershipwaits property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Statistics relevant to processes synchronizing access to transaction.'
DetailLevel100
DisplayName'Transaction ownership waits'
DisplayName009'Transaction ownership waits'
HelpIndex0
PerfIndex0
Transactionownershipwaits property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Waitfortheworker property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Statistics relevant to processes waiting for worker to become available.'
DetailLevel100
DisplayName'Wait for the worker'
DisplayName009'Wait for the worker'
HelpIndex0
PerfIndex0
Waitfortheworker property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Workspacesynchronizationwaits property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Statistics relevant to processes synchronizing access to workspace.'
DetailLevel100
DisplayName'Workspace synchronization waits'
DisplayName009'Workspace synchronization waits'
HelpIndex0
PerfIndex0
Workspacesynchronizationwaits property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics 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_SQLServerWaitStatistics Qualifiers

…
NameValueToInstanceToSubclassOverridableAmendedLocal
Description'Wait Statistics'✓✗✓✓✓
DetailLevel100✓✗✓✗✓
DisplayName'SQLServer:Wait Statistics'✓✗✓✓✓
DisplayName009'SQLServer:Wait Statistics'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓

Win32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics System properties

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

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics

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