Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode, ROOT\CIMV2

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

Description

Statistics related to SQL Server's buffer pool by NUMA node

Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode properties

Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode has 13 properties (4 Local, 9 Derived)

NameOriginCIMType
CaptionCIM_StatisticalInformation8 [string]
DatabasepagesWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode21 [uint64]
DescriptionCIM_StatisticalInformation8 [string]
Frequency_ObjectWin32_Perf21 [uint64]
Frequency_PerfTimeWin32_Perf21 [uint64]
Frequency_Sys100NSWin32_Perf21 [uint64]
LocalnodepagelookupsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode21 [uint64]
key
Name
CIM_StatisticalInformation8 [string]
PagelifeexpectancyWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode21 [uint64]
RemotenodepagelookupsPersecWin32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode21 [uint64]
Timestamp_ObjectWin32_Perf21 [uint64]
Timestamp_PerfTimeWin32_Perf21 [uint64]
Timestamp_Sys100NSWin32_Perf21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode properties

Local properties (4) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode class

Databasepages property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Databasepages'
CounterType65792
Description'Database pages on node.'
DisplayName'Database pages'
DisplayName009'Database pages'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Databasepages property is in 8 classes of ROOT\cimv2 and in 1 namespace
LocalnodepagelookupsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'LocalnodepagelookupsPersec'
CounterType272696576
Description'Number of lookup requests from this node which were satisfied from this node.'
DisplayName'Local node page lookups/sec'
DisplayName009'Local node page lookups/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
LocalnodepagelookupsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace
Pagelifeexpectancy property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_LARGE_RAWCOUNT'
Counter'Pagelifeexpectancy'
CounterType65792
Description'Number of seconds a page will stay in the buffer pool without references.'
DisplayName'Page life expectancy'
DisplayName009'Page life expectancy'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
Pagelifeexpectancy property is in 8 classes of ROOT\cimv2 and in 1 namespace
RemotenodepagelookupsPersec property
CIMTYPE'uint64'
CookingType'PERF_COUNTER_BULK_COUNT'
Counter'RemotenodepagelookupsPersec'
CounterType272696576
Description'Number of lookup requests from this node which were satisfied from other nodes.'
DisplayName'Remote node page lookups/sec'
DisplayName009'Remote node page lookups/sec'
HelpIndex0
PerfIndex0
PerfTimeFreq'Frequency_PerfTime'
PerfTimeStamp'Timestamp_PerfTime'
RemotenodepagelookupsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode 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. '
keyTrue
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_SQLServerBufferNode Qualifiers

NameValueToInstanceToSubclassOverridableAmendedLocal
AutoCook1
AutoCook_RawClass'Win32_PerfRawData_MSSQLSERVER_SQLServerBufferNode'
CookedTrue
Description'Statistics related to SQL Server's buffer pool by NUMA node'
DisplayName'SQLServer:Buffer Node'
DisplayName009'SQLServer:Buffer Node'
dynamicTrue
GenericPerfCtrTrue
HelpIndex0
HiPerfTrue
Locale1033
PerfIndex0
provider'WmiPerfInst'
RegistryKey'MSSQLSERVER'

Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode System properties

NameValueOriginCIMTypeLocalArray
__PATH'\\.\ROOT\cimv2:Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode'___SYSTEM8
__NAMESPACE'ROOT\cimv2'___SYSTEM8
__SERVER'.'___SYSTEM8
__DERIVATION['Win32_PerfFormattedData', 'Win32_Perf', 'CIM_StatisticalInformation']___SYSTEM8
__PROPERTY_COUNT13___SYSTEM3
__RELPATH'Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode'___SYSTEM8
__DYNASTY'CIM_StatisticalInformation'___SYSTEM8
__SUPERCLASS'Win32_PerfFormattedData'___SYSTEM8
__CLASS'Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode'___SYSTEM8
__GENUS1___SYSTEM3

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode

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