Win32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics, ROOT\CIMV2

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

Description

Collects statistics associated with SQL requests

Win32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics properties

Win32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics has 20 properties (11 Local, 9 Derived)

NameOriginCIMType
AutoParamAttemptsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
BatchRequestsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
DescriptionCIM_StatisticalInformation8 [string]
FailedAutoParamsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
ForcedParameterizationsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
GuidedplanexecutionsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
MisguidedplanexecutionsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
NameCIM_StatisticalInformation8 [string]
SafeAutoParamsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
SQLAttentionrateWin32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
SQLCompilationsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
SQLReCompilationsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
UnsafeAutoParamsPersecWin32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics properties

Local properties (11) of Win32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics class

AutoParamAttemptsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Number of auto-parameterization attempts.'
DetailLevel100
DisplayName'Auto-Param Attempts/sec'
DisplayName009'Auto-Param Attempts/sec'
HelpIndex0
PerfIndex0
AutoParamAttemptsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
BatchRequestsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of SQL batch requests received by server.'
DetailLevel100
DisplayName'Batch Requests/sec'
DisplayName009'Batch Requests/sec'
HelpIndex0
PerfDefaultTrue
PerfIndex0
BatchRequestsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
FailedAutoParamsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Number of failed auto-parameterizations.'
DetailLevel100
DisplayName'Failed Auto-Params/sec'
DisplayName009'Failed Auto-Params/sec'
HelpIndex0
PerfIndex0
FailedAutoParamsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
ForcedParameterizationsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Number of statements parameterized by forced parameterization per second.'
DetailLevel100
DisplayName'Forced Parameterizations/sec'
DisplayName009'Forced Parameterizations/sec'
HelpIndex0
PerfIndex0
ForcedParameterizationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
GuidedplanexecutionsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of plan executions per second in which the query plan has been generated by using a plan guide.'
DetailLevel100
DisplayName'Guided plan executions/sec'
DisplayName009'Guided plan executions/sec'
HelpIndex0
PerfIndex0
GuidedplanexecutionsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
MisguidedplanexecutionsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of plan executions per second in which a plan guide could not be honored during plan generation. The plan guide was disregarded and normal compilation was used to generate the executed plan.'
DetailLevel100
DisplayName'Misguided plan executions/sec'
DisplayName009'Misguided plan executions/sec'
HelpIndex0
PerfIndex0
MisguidedplanexecutionsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
SafeAutoParamsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Number of safe auto-parameterizations.'
DetailLevel100
DisplayName'Safe Auto-Params/sec'
DisplayName009'Safe Auto-Params/sec'
HelpIndex0
PerfIndex0
SafeAutoParamsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
SQLAttentionrate property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of attentions per second.'
DetailLevel100
DisplayName'SQL Attention rate'
DisplayName009'SQL Attention rate'
HelpIndex0
PerfIndex0
SQLAttentionrate property is in 4 classes of ROOT\cimv2 and in 1 namespace
SQLCompilationsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of SQL compilations.'
DetailLevel100
DisplayName'SQL Compilations/sec'
DisplayName009'SQL Compilations/sec'
HelpIndex0
PerfIndex0
SQLCompilationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
SQLReCompilationsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale0
Description'Number of SQL re-compiles.'
DetailLevel100
DisplayName'SQL Re-Compilations/sec'
DisplayName009'SQL Re-Compilations/sec'
HelpIndex0
PerfIndex0
SQLReCompilationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
UnsafeAutoParamsPersec property
CIMTYPE'uint64'
CounterType272696576
DefaultScale-2
Description'Number of unsafe auto-parameterizations.'
DetailLevel100
DisplayName'Unsafe Auto-Params/sec'
DisplayName009'Unsafe Auto-Params/sec'
HelpIndex0
PerfIndex0
UnsafeAutoParamsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics 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_SQLServerSQLStatistics Qualifiers

NameValueToInstanceToSubclassOverridableAmendedLocal
Description'Collects statistics associated with SQL requests'
DetailLevel100
DisplayName'SQLServer:SQL Statistics'
DisplayName009'SQLServer:SQL Statistics'
dynamicTrue
GenericPerfCtrTrue
HelpIndex0
HiPerfTrue
Locale1033
PerfIndex0
provider'WmiPerfInst'
RegistryKey'MSSQLSERVER'
SingletonTrue

Win32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics System properties

NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics'___SYSTEM8
__NAMESPACE'ROOT\cimv2'___SYSTEM8
__SERVER'.'___SYSTEM8
__DERIVATION['Win32_PerfRawData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8
__PROPERTY_COUNT20___SYSTEM3
__RELPATH'Win32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics'___SYSTEM8
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8
__SUPERCLASS'Win32_PerfRawData'___SYSTEM8
__CLASS'Win32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics'___SYSTEM8
__GENUS1___SYSTEM3

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics

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