Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache, ROOT\CIMV2

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

Description

This defines cache counters

Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache properties

Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache has 13 properties (4 Local, 9 Derived)

Name	Origin	CIMType
CacheHitRatio	Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache	21 [uint64]
CacheObjectCounts	Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache	21 [uint64]
CacheObjectsinuse	Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache	21 [uint64]
CachePages	Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache	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_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache properties

Local properties (4) of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache class

▲ CacheHitRatio property
CIMTYPE	'uint64'
CookingType	''
Counter	'CacheHitRatio'
CounterType	537003264
Description	'Ratio between cache hits and lookups'
DisplayName	'Cache Hit Ratio'
DisplayName009	'Cache Hit Ratio'
HelpIndex	0
PerfIndex	0
PerfTimeFreq	'Frequency_PerfTime'
PerfTimeStamp	'Timestamp_PerfTime'
CacheHitRatio property is in 12 classes of ROOT\cimv2 and in 1 namespace

▲ CacheObjectCounts property
CIMTYPE	'uint64'
CookingType	'PERF_COUNTER_LARGE_RAWCOUNT'
Counter	'CacheObjectCounts'
CounterType	65792
Description	'Number of cache objects in the cache'
DisplayName	'Cache Object Counts'
DisplayName009	'Cache Object Counts'
HelpIndex	0
PerfIndex	0
PerfTimeFreq	'Frequency_PerfTime'
PerfTimeStamp	'Timestamp_PerfTime'
CacheObjectCounts property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ CacheObjectsinuse property
CIMTYPE	'uint64'
CookingType	'PERF_COUNTER_LARGE_RAWCOUNT'
Counter	'CacheObjectsinuse'
CounterType	65792
Description	'Number of cache objects in use'
DisplayName	'Cache Objects in use'
DisplayName009	'Cache Objects in use'
HelpIndex	0
PerfIndex	0
PerfTimeFreq	'Frequency_PerfTime'
PerfTimeStamp	'Timestamp_PerfTime'
CacheObjectsinuse property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ CachePages property
CIMTYPE	'uint64'
CookingType	'PERF_COUNTER_LARGE_RAWCOUNT'
Counter	'CachePages'
CounterType	65792
Description	'Number of 8k pages used by cache objects'
DisplayName	'Cache Pages'
DisplayName009	'Cache Pages'
HelpIndex	0
PerfIndex	0
PerfTimeFreq	'Frequency_PerfTime'
PerfTimeStamp	'Timestamp_PerfTime'
CachePages property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache 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_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache Qualifiers

Name	Value	ToInstance	ToSubclass	Overridable	Amended	Local
AutoCook	1	✓	✗	✓	✗	✓
AutoCook_RawClass	'Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache'	✓	✗	✓	✗	✓
Cooked	True	✓	✗	✓	✗	✓
Description	'This defines cache counters'	✓	✗	✓	✓	✓
DisplayName	'MSSQL$MICROSOFT##WID:Plan Cache'	✓	✗	✓	✓	✓
DisplayName009	'MSSQL$MICROSOFT##WID:Plan Cache'	✓	✗	✓	✗	✓
dynamic	True	✓	✗	✓	✗	✓
GenericPerfCtr	True	✓	✗	✓	✗	✓
HelpIndex	0	✓	✗	✓	✗	✓
HiPerf	True	✓	✗	✓	✗	✓
Locale	1033	✓	✗	✓	✓	✓
PerfIndex	0	✓	✗	✓	✗	✓
provider	'WmiPerfInst'	✗	✗	✓	✗	✓
RegistryKey	'MSSQL$MICROSOFT##WID'	✓	✗	✓	✗	✓

Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache System properties

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

Similar Classes to Win32_PerfFormattedData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache

Number of classes:1

Class name	Childs	Properties	Methods	Class Instances	Child Instances	Abstract	Singleton
Win32_PerfRawData_MSSQLMICROSOFTNumberNumberWID_MSSQLMICROSOFTNumberNumberWIDPlanCache	0	14	0	6	-	-	-

comments powered by Disqus