WUtils.com

Win32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics, ROOT\CIMV2

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

Description

Collects statistics associated with SQL requests

Win32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics properties

Win32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics has 20 properties (11 Local, 9 Derived)

NameOriginCIMType
AutoParamAttemptsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
BatchRequestsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
CaptionCIM_StatisticalInformation8 [string]
DescriptionCIM_StatisticalInformation8 [string]
FailedAutoParamsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
ForcedParameterizationsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
GuidedplanexecutionsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
MisguidedplanexecutionsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
NameCIM_StatisticalInformation8 [string]
SafeAutoParamsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
SQLAttentionrateWin32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
SQLCompilationsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
SQLReCompilationsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]
UnsafeAutoParamsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics properties

Local properties (11) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics class

…
▲ AutoParamAttemptsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'AutoParamAttemptsPersec'
CounterType272696576
Description'Number of auto-parameterization attempts.'
DisplayName'Auto-Param Attempts/sec'
DisplayName009'Auto-Param Attempts/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
AutoParamAttemptsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ BatchRequestsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'BatchRequestsPersec'
CounterType272696576
Description'Number of SQL batch requests received by server.'
DisplayName'Batch Requests/sec'
DisplayName009'Batch Requests/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
BatchRequestsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ FailedAutoParamsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'FailedAutoParamsPersec'
CounterType272696576
Description'Number of failed auto-parameterizations.'
DisplayName'Failed Auto-Params/sec'
DisplayName009'Failed Auto-Params/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
FailedAutoParamsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ ForcedParameterizationsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'ForcedParameterizationsPersec'
CounterType272696576
Description'Number of statements parameterized by forced parameterization per second.'
DisplayName'Forced Parameterizations/sec'
DisplayName009'Forced Parameterizations/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
ForcedParameterizationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ GuidedplanexecutionsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'GuidedplanexecutionsPersec'
CounterType272696576
Description'Number of plan executions per second in which the query plan has been generated by using a plan guide.'
DisplayName'Guided plan executions/sec'
DisplayName009'Guided plan executions/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
GuidedplanexecutionsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ MisguidedplanexecutionsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'MisguidedplanexecutionsPersec'
CounterType272696576
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.'
DisplayName'Misguided plan executions/sec'
DisplayName009'Misguided plan executions/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
MisguidedplanexecutionsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SafeAutoParamsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'SafeAutoParamsPersec'
CounterType272696576
Description'Number of safe auto-parameterizations.'
DisplayName'Safe Auto-Params/sec'
DisplayName009'Safe Auto-Params/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
SafeAutoParamsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SQLAttentionrate property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'SQLAttentionrate'
CounterType272696576
Description'Number of attentions per second.'
DisplayName'SQL Attention rate'
DisplayName009'SQL Attention rate'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
SQLAttentionrate property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SQLCompilationsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'SQLCompilationsPersec'
CounterType272696576
Description'Number of SQL compilations.'
DisplayName'SQL Compilations/sec'
DisplayName009'SQL Compilations/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
SQLCompilationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ SQLReCompilationsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'SQLReCompilationsPersec'
CounterType272696576
Description'Number of SQL re-compiles.'
DisplayName'SQL Re-Compilations/sec'
DisplayName009'SQL Re-Compilations/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
SQLReCompilationsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
…
▲ UnsafeAutoParamsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'UnsafeAutoParamsPersec'
CounterType272696576
Description'Number of unsafe auto-parameterizations.'
DisplayName'Unsafe Auto-Params/sec'
DisplayName009'Unsafe Auto-Params/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
UnsafeAutoParamsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace

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

…
NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1✓✗✓✗✓
AutoCook_RawClass'Win32_PerfRawData_MSSQLSERVER_SQLServerSQLStatistics'✓✗✓✗✓
CookedTrue✓✗✓✗✓
Description'Collects statistics associated with SQL requests'✓✗✓✓✓
DisplayName'SQLServer:SQL Statistics'✓✗✓✓✓
DisplayName009'SQLServer:SQL Statistics'✓✗✓✗✓
dynamicTrue✓✗✓✗✓
GenericPerfCtrTrue✓✗✓✗✓
HelpIndex0✓✗✓✗✓
HiPerfTrue✓✗✓✗✓
Locale1033✓✗✓✓✓
PerfIndex0✓✗✓✗✓
provider'WmiPerfInst'✗✗✓✗✓
RegistryKey'MSSQLSERVER'✓✗✓✗✓
SingletonTrue✓✓✗✗✓

Win32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics System properties

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

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerSQLStatistics

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