Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache, ROOT\CIMV2

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

Description

This defines cache counters

Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache properties

Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache has 14 properties (5 Local, 9 Derived)

Name	Origin	CIMType
CacheHitRatio	Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache	21 [uint64]
CacheHitRatio_Base	Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache	21 [uint64]
CacheObjectCounts	Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache	21 [uint64]
CacheObjectsinuse	Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache	21 [uint64]
CachePages	Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache	21 [uint64]
Caption	CIM_StatisticalInformation	8 [string]
Description	CIM_StatisticalInformation	8 [string]
Frequency_Object	Win32_Perf	21 [uint64]
Frequency_PerfTime	Win32_Perf	21 [uint64]
Frequency_Sys100NS	Win32_Perf	21 [uint64]
key Name	CIM_StatisticalInformation	8 [string]
Timestamp_Object	Win32_Perf	21 [uint64]
Timestamp_PerfTime	Win32_Perf	21 [uint64]
Timestamp_Sys100NS	Win32_Perf	21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache properties

Local properties (5) of Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache class

▲ CacheHitRatio property
CIMTYPE	'uint64'
CounterType	537003264
DefaultScale	-1
Description	'Ratio between cache hits and lookups'
DetailLevel	100
DisplayName	'Cache Hit Ratio'
DisplayName009	'Cache Hit Ratio'
HelpIndex	0
PerfDefault	True
PerfIndex	0
CacheHitRatio property is in 12 classes of ROOT\cimv2 and in 1 namespace

▲ CacheHitRatio_Base property
CIMTYPE	'uint64'
CounterType	1073939712
DefaultScale	0
Description	''
DetailLevel	100
DisplayName	''
DisplayName009	''
HelpIndex	0
PerfIndex	0
CacheHitRatio_Base property is in 6 classes of ROOT\cimv2 and in 1 namespace

▲ CacheObjectCounts property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	-1
Description	'Number of cache objects in the cache'
DetailLevel	100
DisplayName	'Cache Object Counts'
DisplayName009	'Cache Object Counts'
HelpIndex	0
PerfIndex	0
CacheObjectCounts property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ CacheObjectsinuse property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	-1
Description	'Number of cache objects in use'
DetailLevel	100
DisplayName	'Cache Objects in use'
DisplayName009	'Cache Objects in use'
HelpIndex	0
PerfIndex	0
CacheObjectsinuse property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ CachePages property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	-1
Description	'Number of 8k pages used by cache objects'
DetailLevel	100
DisplayName	'Cache Pages'
DisplayName009	'Cache Pages'
HelpIndex	0
PerfIndex	0
CachePages property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache class

▲ Caption property
CIMTYPE	'string'
Description	'A short textual description (one-line string) for the statistic or metric.'
MaxLen	64
read	True
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.'
read	True
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. '
key	True
MaxLen	256
read	True
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_SQLServerPlanCache Qualifiers

Name	Value	ToInstance	ToSubclass	Overridable	Amended	Local
Description	'This defines cache counters'	✓	✗	✓	✓	✓
DetailLevel	100	✓	✗	✓	✗	✓
DisplayName	'SQLServer:Plan Cache'	✓	✗	✓	✓	✓
DisplayName009	'SQLServer:Plan Cache'	✓	✗	✓	✗	✓
dynamic	True	✓	✗	✓	✗	✓
GenericPerfCtr	True	✓	✗	✓	✗	✓
HelpIndex	0	✓	✗	✓	✗	✓
HiPerf	True	✓	✗	✓	✗	✓
Locale	1033	✓	✗	✓	✓	✓
PerfIndex	0	✓	✗	✓	✗	✓
provider	'WmiPerfInst'	✗	✗	✓	✗	✓
RegistryKey	'MSSQLSERVER'	✓	✗	✓	✗	✓

Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache System properties

Name	Value	Origin	CIMType	Local	Array
__PATH	'\\.\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache'	___SYSTEM	8	✗	✗
__NAMESPACE	'ROOT\cimv2'	___SYSTEM	8	✗	✗
__SERVER	'.'	___SYSTEM	8	✗	✗
__DERIVATION	['Win32_PerfRawData', 'Win32_Perf', 'CIM_StatisticalInformation']	___SYSTEM	8	✗	✓
__PROPERTY_COUNT	14	___SYSTEM	3	✗	✗
__RELPATH	'Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache'	___SYSTEM	8	✗	✗
__DYNASTY	'CIM_StatisticalInformation'	___SYSTEM	8	✗	✗
__SUPERCLASS	'Win32_PerfRawData'	___SYSTEM	8	✗	✗
__CLASS	'Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache'	___SYSTEM	8	✗	✗
__GENUS	1	___SYSTEM	3	✗	✗

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache

Number of classes:1

Class name	Childs	Properties	Methods	Class Instances	Child Instances	Abstract	Singleton
Win32_PerfFormattedData_MSSQLSERVER_SQLServerPlanCache	0	13	0	6	-	-	-

comments powered by Disqus