Win32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics, ROOT\CIMV2

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

Description

Wait Statistics

Win32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics properties

Win32_PerfFormattedData_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_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
LogbufferwaitsWin32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
LogwritewaitsWin32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
MemorygrantqueuewaitsWin32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
key
Name
CIM_StatisticalInformation8 [string]
NetworkIOwaitsWin32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
NonPagelatchwaitsWin32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
PageIOlatchwaitsWin32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
PagelatchwaitsWin32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
ThreadsafememoryobjectswaitsWin32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
TransactionownershipwaitsWin32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
WaitfortheworkerWin32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]
WorkspacesynchronizationwaitsWin32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics properties

Local properties (12) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics class

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

Derived properties (9) of Win32_PerfFormattedData_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_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics Qualifiers

NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1
AutoCook_RawClass'Win32_PerfRawData_MSSQLSERVER_SQLServerWaitStatistics'
CookedTrue
Description'Wait Statistics'
DisplayName'SQLServer:Wait Statistics'
DisplayName009'SQLServer:Wait Statistics'
dynamicTrue
GenericPerfCtrTrue
HelpIndex0
HiPerfTrue
Locale1033
PerfIndex0
provider'WmiPerfInst'
RegistryKey'MSSQLSERVER'

Win32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics System properties

NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics'___SYSTEM8
__NAMESPACE'ROOT\cimv2'___SYSTEM8
__SERVER'.'___SYSTEM8
__DERIVATION['Win32_PerfFormattedData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8
__PROPERTY_COUNT21___SYSTEM3
__RELPATH'Win32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics'___SYSTEM8
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8
__SUPERCLASS'Win32_PerfFormattedData'___SYSTEM8
__CLASS'Win32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics'___SYSTEM8
__GENUS1___SYSTEM3

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerWaitStatistics

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