WUtils.com

Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics, ROOT\CIMV2

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

Description

Server General Statistics

Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics properties

Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics has 33 properties (24 Local, 9 Derived)

NameOriginCIMType
ActiveTempTablesWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
ConnectionResetPersecWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
EventNotificationsDelayedDropWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
HTTPAuthenticatedRequestsWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
LogicalConnectionsWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
LoginsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
LogoutsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
MarsDeadlocksWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
NameCIM_StatisticalInformation8 [string]
NonatomicyieldrateWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
ProcessesblockedWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
SOAPEmptyRequestsWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
SOAPMethodInvocationsWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
SOAPSessionInitiateRequestsWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
SOAPSessionTerminateRequestsWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
SOAPSQLRequestsWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
SOAPWSDLRequestsWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
SQLTraceIOProviderLockWaitsWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
TempdbrecoveryunitidWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
TempdbrowsetidWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
TempTablesCreationRateWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
TempTablesForDestructionWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
TraceEventNotificationQueueWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
TransactionsWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
UserConnectionsWin32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics properties

Local properties (24) of Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics class

…
▲ ActiveTempTables property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of temporary tables/table variables in use'
DetailLevel100
DisplayName'Active Temp Tables'
DisplayName009'Active Temp Tables'
HelpIndex0
PerfDefaultTrue
PerfIndex0
ActiveTempTables property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ ConnectionResetPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of connection resets per second.'
DetailLevel100
DisplayName'Connection Reset/sec'
DisplayName009'Connection Reset/sec'
HelpIndex0
PerfIndex0
ConnectionResetPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ EventNotificationsDelayedDrop property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of event notifications waiting to be dropped by a system thread'
DetailLevel100
DisplayName'Event Notifications Delayed Drop'
DisplayName009'Event Notifications Delayed Drop'
HelpIndex0
PerfIndex0
EventNotificationsDelayedDrop property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ HTTPAuthenticatedRequests property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of authenticated HTTP requests started per second.'
DetailLevel100
DisplayName'HTTP Authenticated Requests'
DisplayName009'HTTP Authenticated Requests'
HelpIndex0
PerfIndex0
HTTPAuthenticatedRequests property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogicalConnections property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of logical connections to the system.'
DetailLevel100
DisplayName'Logical Connections'
DisplayName009'Logical Connections'
HelpIndex0
PerfIndex0
LogicalConnections property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LoginsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of logins started per second.'
DetailLevel100
DisplayName'Logins/sec'
DisplayName009'Logins/sec'
HelpIndex0
PerfIndex0
LoginsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ LogoutsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Total number of logouts started per second.'
DetailLevel100
DisplayName'Logouts/sec'
DisplayName009'Logouts/sec'
HelpIndex0
PerfIndex0
LogoutsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ MarsDeadlocks property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of Mars Deadlocks detected.'
DetailLevel100
DisplayName'Mars Deadlocks'
DisplayName009'Mars Deadlocks'
HelpIndex0
PerfIndex0
MarsDeadlocks property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Nonatomicyieldrate property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of non-atomic yields per second.'
DetailLevel100
DisplayName'Non-atomic yield rate'
DisplayName009'Non-atomic yield rate'
HelpIndex0
PerfIndex0
Nonatomicyieldrate property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Processesblocked property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of currently blocked processes.'
DetailLevel100
DisplayName'Processes blocked'
DisplayName009'Processes blocked'
HelpIndex0
PerfIndex0
Processesblocked property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SOAPEmptyRequests property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of empty SOAP requests started per second.'
DetailLevel100
DisplayName'SOAP Empty Requests'
DisplayName009'SOAP Empty Requests'
HelpIndex0
PerfIndex0
SOAPEmptyRequests property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SOAPMethodInvocations property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of SOAP method invocations started per second.'
DetailLevel100
DisplayName'SOAP Method Invocations'
DisplayName009'SOAP Method Invocations'
HelpIndex0
PerfIndex0
SOAPMethodInvocations property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SOAPSessionInitiateRequests property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of SOAP Session initiate requests started per second.'
DetailLevel100
DisplayName'SOAP Session Initiate Requests'
DisplayName009'SOAP Session Initiate Requests'
HelpIndex0
PerfIndex0
SOAPSessionInitiateRequests property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SOAPSessionTerminateRequests property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of SOAP Session terminate requests started per second.'
DetailLevel100
DisplayName'SOAP Session Terminate Requests'
DisplayName009'SOAP Session Terminate Requests'
HelpIndex0
PerfIndex0
SOAPSessionTerminateRequests property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SOAPSQLRequests property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of SOAP SQL requests started per second.'
DetailLevel100
DisplayName'SOAP SQL Requests'
DisplayName009'SOAP SQL Requests'
HelpIndex0
PerfIndex0
SOAPSQLRequests property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SOAPWSDLRequests property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of SOAP Web Service Description Language requests started per second.'
DetailLevel100
DisplayName'SOAP WSDL Requests'
DisplayName009'SOAP WSDL Requests'
HelpIndex0
PerfIndex0
SOAPWSDLRequests property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SQLTraceIOProviderLockWaits property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of waits for the File IO Provider lock per second'
DetailLevel100
DisplayName'SQL Trace IO Provider Lock Waits'
DisplayName009'SQL Trace IO Provider Lock Waits'
HelpIndex0
PerfIndex0
SQLTraceIOProviderLockWaits property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Tempdbrecoveryunitid property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of duplicate tempdb recovery unit id generated'
DetailLevel100
DisplayName'Tempdb recovery unit id'
DisplayName009'Tempdb recovery unit id'
HelpIndex0
PerfIndex0
Tempdbrecoveryunitid property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Tempdbrowsetid property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of duplicate tempdb rowset id generated'
DetailLevel100
DisplayName'Tempdb rowset id'
DisplayName009'Tempdb rowset id'
HelpIndex0
PerfIndex0
Tempdbrowsetid property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TempTablesCreationRate property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of temporary tables/table variables created/sec'
DetailLevel100
DisplayName'Temp Tables Creation Rate'
DisplayName009'Temp Tables Creation Rate'
HelpIndex0
PerfIndex0
TempTablesCreationRate property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TempTablesForDestruction property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of temporary tables/table variables waiting to be destroyed by the cleanup system thread'
DetailLevel100
DisplayName'Temp Tables For Destruction'
DisplayName009'Temp Tables For Destruction'
HelpIndex0
PerfIndex0
TempTablesForDestruction property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ TraceEventNotificationQueue property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of trace event notification instances waiting in the internal queue to be sent thru Service Broker'
DetailLevel100
DisplayName'Trace Event Notification Queue'
DisplayName009'Trace Event Notification Queue'
HelpIndex0
PerfIndex0
TraceEventNotificationQueue property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ Transactions property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of transaction enlistments (local, dtc, and bound).'
DetailLevel100
DisplayName'Transactions'
DisplayName009'Transactions'
HelpIndex0
PerfIndex0
Transactions property is in 8 classes of ROOT\cimv2 and in 1 namespace
…
▲ UserConnections property
CIMTYPE'uint64'
CounterType65792
DefaultScale0
Description'Number of users connected to the system.'
DetailLevel100
DisplayName'User Connections'
DisplayName009'User Connections'
HelpIndex0
PerfIndex0
UserConnections property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics 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. '
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_SQLServerGeneralStatistics Qualifiers

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

Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics System properties

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

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics

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