Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache, ROOT\cimv2 - Instances

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

Instances of Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache

This section contains sample wmi instances of Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache class with their properties from Microsoft Windows Server 2012 R2 Datacenter Evaluation.

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache.Name="Temporary Tables & Table Variables"

Properties={
   'CacheHitRatio' : '0' //String, 0x0
   'CacheHitRatio_Base' : '0' //String, 0x0
   'CacheObjectCounts' : '7' //String, 0x7
   'CacheObjectsinuse' : '0' //String, 0x0
   'CachePages' : '2' //String, 0x2
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '0' //String, 0x0
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'Name' : 'Temporary Tables & Table Variables' //String
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '0' //String, 0x0
   'Timestamp_Sys100NS' : '130603634121620000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache.Name="Extended Stored Procedures"

Properties={
   'CacheHitRatio' : '0' //String, 0x0
   'CacheHitRatio_Base' : '0' //String, 0x0
   'CacheObjectCounts' : '0' //String, 0x0
   'CacheObjectsinuse' : '0' //String, 0x0
   'CachePages' : '2' //String, 0x2
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '0' //String, 0x0
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'Name' : 'Extended Stored Procedures' //String
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '0' //String, 0x0
   'Timestamp_Sys100NS' : '130603634121620000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache.Name="Bound Trees"

Properties={
   'CacheHitRatio' : '0' //String, 0x0
   'CacheHitRatio_Base' : '0' //String, 0x0
   'CacheObjectCounts' : '3' //String, 0x3
   'CacheObjectsinuse' : '0' //String, 0x0
   'CachePages' : '10' //String, 0xA
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '0' //String, 0x0
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'Name' : 'Bound Trees' //String
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '0' //String, 0x0
   'Timestamp_Sys100NS' : '130603634121620000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache.Name="SQL Plans"

Properties={
   'CacheHitRatio' : '0' //String, 0x0
   'CacheHitRatio_Base' : '0' //String, 0x0
   'CacheObjectCounts' : '0' //String, 0x0
   'CacheObjectsinuse' : '0' //String, 0x0
   'CachePages' : '204' //String, 0xCC
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '0' //String, 0x0
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'Name' : 'SQL Plans' //String
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '0' //String, 0x0
   'Timestamp_Sys100NS' : '130603634121620000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache.Name="Object Plans"

Properties={
   'CacheHitRatio' : '0' //String, 0x0
   'CacheHitRatio_Base' : '0' //String, 0x0
   'CacheObjectCounts' : '10' //String, 0xA
   'CacheObjectsinuse' : '0' //String, 0x0
   'CachePages' : '413' //String, 0x19D
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '0' //String, 0x0
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'Name' : 'Object Plans' //String
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '0' //String, 0x0
   'Timestamp_Sys100NS' : '130603634121620000' //String
}

Instance \\W2012SDC\ROOT\cimv2:Win32_PerfRawData_MSSQLSERVER_SQLServerPlanCache.Name="_Total"

Properties={
   'CacheHitRatio' : '0' //String, 0x0
   'CacheHitRatio_Base' : '0' //String, 0x0
   'CacheObjectCounts' : '20' //String, 0x14
   'CacheObjectsinuse' : '0' //String, 0x0
   'CachePages' : '631' //String, 0x277
   'Caption' : null
   'Description' : null
   'Frequency_Object' : '0' //String, 0x0
   'Frequency_PerfTime' : '0' //String, 0x0
   'Frequency_Sys100NS' : '10000000' //String, 0x989680
   'Name' : '_Total' //String
   'Timestamp_Object' : '0' //String, 0x0
   'Timestamp_PerfTime' : '0' //String, 0x0
   'Timestamp_Sys100NS' : '130603634121620000' //String
}
comments powered by Disqus
WUtils.com