| Win32_PerfFormattedData_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 | |||
| [Description("Server General Statistics"): ToInstance Amended, DisplayName("SQLServer:General Statistics"): ToInstance Amended, genericperfctr: ToInstance Amended, locale(1033): ToInstance Amended] instance of Win32_PerfFormattedData_MSSQLSERVER_SQLServerGeneralStatistics { [Description("Number of temporary tables/table variables in use"): ToInstance Amended, DisplayName("Active Temp Tables"): ToInstance Amended] ActiveTempTables = "0"; [Description("Number of event notifications waiting to be dropped by a system thread"): ToInstance Amended, DisplayName("Event Notifications Delayed Drop"): ToInstance Amended] EventNotificationsDelayedDrop = "0"; [Description("Number of authenticated HTTP requests started per second."): ToInstance Amended, DisplayName("HTTP Authenticated Requests"): ToInstance Amended] HTTPAuthenticatedRequests = "0"; [Description("Number of logical connections to the system."): ToInstance Amended, DisplayName("Logical Connections"): ToInstance Amended] LogicalConnections = "0"; [Description("Total number of logins started per second."): ToInstance Amended, DisplayName("Logins/sec"): ToInstance Amended] LoginsPersec = "0"; [Description("Total number of logouts started per second."): ToInstance Amended, DisplayName("Logouts/sec"): ToInstance Amended] LogoutsPersec = "0"; [Description("Number of Mars Deadlocks detected."): ToInstance Amended, DisplayName("Mars Deadlocks"): ToInstance Amended] MarsDeadlocks = "0"; [Description("Number of non-atomic yields per second."): ToInstance Amended, DisplayName("Non-atomic yield rate"): ToInstance Amended] Nonatomicyieldrate = "0"; [Description("Number of currently blocked processes."): ToInstance Amended, DisplayName("Processes blocked"): ToInstance Amended] Processesblocked = "0"; [Description("Number of empty SOAP requests started per second."): ToInstance Amended, DisplayName("SOAP Empty Requests"): ToInstance Amended] SOAPEmptyRequests = "0"; [Description("Number of SOAP method invocations started per second."): ToInstance Amended, DisplayName("SOAP Method Invocations"): ToInstance Amended] SOAPMethodInvocations = "0"; [Description("Number of SOAP Session initiate requests started per second."): ToInstance Amended, DisplayName("SOAP Session Initiate Requests"): ToInstance Amended] SOAPSessionInitiateRequests = "0"; [Description("Number of SOAP Session terminate requests started per second."): ToInstance Amended, DisplayName("SOAP Session Terminate Requests"): ToInstance Amended] SOAPSessionTerminateRequests = "0"; [Description("Number of SOAP SQL requests started per second."): ToInstance Amended, DisplayName("SOAP SQL Requests"): ToInstance Amended] SOAPSQLRequests = "0"; [Description("Number of SOAP Web Service Description Language requests started per second."): ToInstance Amended, DisplayName("SOAP WSDL Requests"): ToInstance Amended] SOAPWSDLRequests = "0"; [Description("Number of waits for the File IO Provider lock per second"): ToInstance Amended, DisplayName("SQL Trace IO Provider Lock Waits"): ToInstance Amended] SQLTraceIOProviderLockWaits = "0"; [Description("Number of temporary tables/table variables created/sec"): ToInstance Amended, DisplayName("Temp Tables Creation Rate"): ToInstance Amended] TempTablesCreationRate = "0"; [Description("Number of temporary tables/table variables waiting to be destroyed by the cleanup system thread"): ToInstance Amended, DisplayName("Temp Tables For Destruction"): ToInstance Amended] TempTablesForDestruction = "0"; [Description("Number of trace event notification instances waiting in the internal queue to be sent thru Service Broker"): ToInstance Amended, DisplayName("Trace Event Notification Queue"): ToInstance Amended] TraceEventNotificationQueue = "0"; [Description("Number of transaction enlistments (local, dtc, and bound)."): ToInstance Amended, DisplayName("Transactions"): ToInstance Amended] Transactions = "0"; [Description("Number of users connected to the system."): ToInstance Amended, DisplayName("User Connections"): ToInstance Amended] UserConnections = "0"; }; | |||