| Win32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics | |||
| Collects statistics associated with SQL requests | |||
| NameSpace Path | |||
| \ROOT\CIMV2 | |||
| PROPERTY | SMS_REPORT | CIMTYPE | DESCRIPTION |
| AutoParamAttemptsPersec | UInt64 | Number of auto-parameterization attempts. | |
| BatchRequestsPersec | UInt64 | Number of SQL batch requests received by server. | |
| Caption | String | A short textual description (one-line string) for the statistic or metric. | |
| Description | String | A textual description of the statistic or metric. | |
| FailedAutoParamsPersec | UInt64 | Number of failed auto-parameterizations. | |
| ForcedParameterizationsPersec | UInt64 | Number of statements parameterized by forced parameterization per second. | |
| Frequency_Object | UInt64 | NA | |
| Frequency_PerfTime | UInt64 | NA | |
| Frequency_Sys100NS | UInt64 | NA | |
| 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. | |
| SafeAutoParamsPersec | UInt64 | Number of safe auto-parameterizations. | |
| SQLAttentionrate | UInt64 | Number of attentions per second. | |
| SQLCompilationsPersec | UInt64 | Number of SQL compilations. | |
| SQLReCompilationsPersec | UInt64 | Number of SQL re-compiles. | |
| Timestamp_Object | UInt64 | NA | |
| Timestamp_PerfTime | UInt64 | NA | |
| Timestamp_Sys100NS | UInt64 | NA | |
| UnsafeAutoParamsPersec | UInt64 | Number of unsafe auto-parameterizations. | |
| SAMPLE DATA INSTANCE | |||
| [Description("Collects statistics associated with SQL requests"): ToInstance Amended, DisplayName("SQLServer:SQL Statistics"): ToInstance Amended, genericperfctr: ToInstance Amended, locale(1033): ToInstance Amended] instance of Win32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics { [Description("Number of auto-parameterization attempts."): ToInstance Amended, DisplayName("Auto-Param Attempts/sec"): ToInstance Amended] AutoParamAttemptsPersec = "0"; [Description("Number of SQL batch requests received by server."): ToInstance Amended, DisplayName("Batch Requests/sec"): ToInstance Amended] BatchRequestsPersec = "0"; [Description("Number of failed auto-parameterizations."): ToInstance Amended, DisplayName("Failed Auto-Params/sec"): ToInstance Amended] FailedAutoParamsPersec = "0"; [Description("Number of statements parameterized by forced parameterization per second."): ToInstance Amended, DisplayName("Forced Parameterizations/sec"): ToInstance Amended] ForcedParameterizationsPersec = "0"; [Description("Number of safe auto-parameterizations."): ToInstance Amended, DisplayName("Safe Auto-Params/sec"): ToInstance Amended] SafeAutoParamsPersec = "0"; [Description("Number of attentions per second."): ToInstance Amended, DisplayName("SQL Attention rate"): ToInstance Amended] SQLAttentionrate = "0"; [Description("Number of SQL compilations."): ToInstance Amended, DisplayName("SQL Compilations/sec"): ToInstance Amended] SQLCompilationsPersec = "0"; [Description("Number of SQL re-compiles."): ToInstance Amended, DisplayName("SQL Re-Compilations/sec"): ToInstance Amended] SQLReCompilationsPersec = "0"; [Description("Number of unsafe auto-parameterizations."): ToInstance Amended, DisplayName("Unsafe Auto-Params/sec"): ToInstance Amended] UnsafeAutoParamsPersec = "0"; }; | |||