| Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics |
| Server General Statistics |
| NameSpace Path |
| \ROOT\CIMV2 |
| PROPERTY | SMS_REPORT | CIMTYPE | DESCRIPTION |
| ActiveTempTables | | UInt64 | Number of temporary tables/table variables in use |
| Caption | | String | A short textual description (one-line string) for the statistic or metric. |
| Description | | String | A textual description of the statistic or metric. |
| EventNotificationsDelayedDrop | | UInt64 | Number of event notifications waiting to be dropped by a system thread |
| Frequency_Object | | UInt64 | NA |
| Frequency_PerfTime | | UInt64 | NA |
| Frequency_Sys100NS | | UInt64 | NA |
| HTTPAuthenticatedRequests | | UInt64 | Number of authenticated HTTP requests started per second. |
| LogicalConnections | | UInt64 | Number of logical connections to the system. |
| LoginsPersec | | UInt64 | Total number of logins started per second. |
| LogoutsPersec | | UInt64 | Total number of logouts started per second. |
| MarsDeadlocks | | UInt64 | Number of Mars Deadlocks detected. |
| Name | | String | 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. |
| Nonatomicyieldrate | | UInt64 | Number of non-atomic yields per second. |
| Processesblocked | | UInt64 | Number of currently blocked processes. |
| SOAPEmptyRequests | | UInt64 | Number of empty SOAP requests started per second. |
| SOAPMethodInvocations | | UInt64 | Number of SOAP method invocations started per second. |
| SOAPSessionInitiateRequests | | UInt64 | Number of SOAP Session initiate requests started per second. |
| SOAPSessionTerminateRequests | | UInt64 | Number of SOAP Session terminate requests started per second. |
| SOAPSQLRequests | | UInt64 | Number of SOAP SQL requests started per second. |
| SOAPWSDLRequests | | UInt64 | Number of SOAP Web Service Description Language requests started per second. |
| SQLTraceIOProviderLockWaits | | UInt64 | Number of waits for the File IO Provider lock per second |
| TempTablesCreationRate | | UInt64 | Number of temporary tables/table variables created/sec |
| TempTablesForDestruction | | UInt64 | Number of temporary tables/table variables waiting to be destroyed by the cleanup system thread |
| Timestamp_Object | | UInt64 | NA |
| Timestamp_PerfTime | | UInt64 | NA |
| Timestamp_Sys100NS | | UInt64 | NA |
| TraceEventNotificationQueue | | UInt64 | Number of trace event notification instances waiting in the internal queue to be sent thru Service Broker |
| Transactions | | UInt64 | Number of transaction enlistments (local, dtc, and bound). |
| UserConnections | | UInt64 | Number of users connected to the system. |
| SAMPLE DATA INSTANCE |
Class does not currently contain data instances
|
