WUtils.com

Win32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics, ROOT\CIMV2

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

Description

Server General Statistics

Win32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics properties

Win32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics has 33 properties (24 Local, 9 Derived)

NameOriginCIMType
ActiveTempTablesWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
ConnectionResetPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
EventNotificationsDelayedDropWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
HTTPAuthenticatedRequestsWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
LogicalConnectionsWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
LoginsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
LogoutsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
MarsDeadlocksWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
NameCIM_StatisticalInformation8 [string]
NonatomicyieldrateWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
ProcessesblockedWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
SOAPEmptyRequestsWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
SOAPMethodInvocationsWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
SOAPSessionInitiateRequestsWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
SOAPSessionTerminateRequestsWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
SOAPSQLRequestsWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
SOAPWSDLRequestsWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
SQLTraceIOProviderLockWaitsWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
TempdbrecoveryunitidWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
TempdbrowsetidWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
TempTablesCreationRateWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
TempTablesForDestructionWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
TraceEventNotificationQueueWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
TransactionsWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]
UserConnectionsWin32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics properties

Local properties (24) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics class

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

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

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

Win32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics System properties

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

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics

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