Win32_PerfRawData_MSSQLSERVER_SQLServerBufferNode, ROOT\CIMV2

Class | Methods | Properties (13) | Qualifiers (12) | 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_PerfRawData_MSSQLSERVER_SQLServerBufferNode properties

Win32_PerfRawData_MSSQLSERVER_SQLServerBufferNode has 13 properties (4 Local, 9 Derived)

Name	Origin	CIMType
Caption	CIM_StatisticalInformation	8 [string]
Databasepages	Win32_PerfRawData_MSSQLSERVER_SQLServerBufferNode	21 [uint64]
Description	CIM_StatisticalInformation	8 [string]
Frequency_Object	Win32_Perf	21 [uint64]
Frequency_PerfTime	Win32_Perf	21 [uint64]
Frequency_Sys100NS	Win32_Perf	21 [uint64]
LocalnodepagelookupsPersec	Win32_PerfRawData_MSSQLSERVER_SQLServerBufferNode	21 [uint64]
key Name	CIM_StatisticalInformation	8 [string]
Pagelifeexpectancy	Win32_PerfRawData_MSSQLSERVER_SQLServerBufferNode	21 [uint64]
RemotenodepagelookupsPersec	Win32_PerfRawData_MSSQLSERVER_SQLServerBufferNode	21 [uint64]
Timestamp_Object	Win32_Perf	21 [uint64]
Timestamp_PerfTime	Win32_Perf	21 [uint64]
Timestamp_Sys100NS	Win32_Perf	21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerBufferNode properties

Local properties (4) of Win32_PerfRawData_MSSQLSERVER_SQLServerBufferNode class

▲ Databasepages property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	-3
Description	'Database pages on node.'
DetailLevel	100
DisplayName	'Database pages'
DisplayName009	'Database pages'
HelpIndex	0
PerfDefault	True
PerfIndex	0
Databasepages property is in 8 classes of ROOT\cimv2 and in 1 namespace

▲ LocalnodepagelookupsPersec property
CIMTYPE	'uint64'
CounterType	272696576
DefaultScale	-2
Description	'Number of lookup requests from this node which were satisfied from this node.'
DetailLevel	100
DisplayName	'Local node page lookups/sec'
DisplayName009	'Local node page lookups/sec'
HelpIndex	0
PerfIndex	0
LocalnodepagelookupsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ Pagelifeexpectancy property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	-1
Description	'Number of seconds a page will stay in the buffer pool without references.'
DetailLevel	100
DisplayName	'Page life expectancy'
DisplayName009	'Page life expectancy'
HelpIndex	0
PerfIndex	0
Pagelifeexpectancy property is in 8 classes of ROOT\cimv2 and in 1 namespace

▲ RemotenodepagelookupsPersec property
CIMTYPE	'uint64'
CounterType	272696576
DefaultScale	-2
Description	'Number of lookup requests from this node which were satisfied from other nodes.'
DetailLevel	100
DisplayName	'Remote node page lookups/sec'
DisplayName009	'Remote node page lookups/sec'
HelpIndex	0
PerfIndex	0
RemotenodepagelookupsPersec property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_MSSQLSERVER_SQLServerBufferNode 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_SQLServerBufferNode Qualifiers

Name	Value	ToInstance	ToSubclass	Overridable	Amended	Local
Description	'Statistics related to SQL Server's buffer pool by NUMA node'	✓	✗	✓	✓	✓
DetailLevel	100	✓	✗	✓	✗	✓
DisplayName	'SQLServer:Buffer Node'	✓	✗	✓	✓	✓
DisplayName009	'SQLServer:Buffer Node'	✓	✗	✓	✗	✓
dynamic	True	✓	✗	✓	✗	✓
GenericPerfCtr	True	✓	✗	✓	✗	✓
HelpIndex	0	✓	✗	✓	✗	✓
HiPerf	True	✓	✗	✓	✗	✓
Locale	1033	✓	✗	✓	✓	✓
PerfIndex	0	✓	✗	✓	✗	✓
provider	'WmiPerfInst'	✗	✗	✓	✗	✓
RegistryKey	'MSSQLSERVER'	✓	✗	✓	✗	✓

Win32_PerfRawData_MSSQLSERVER_SQLServerBufferNode System properties

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

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerBufferNode

Number of classes:1

Class name	Childs	Properties	Methods	Class Instances	Child Instances	Abstract	Singleton
Win32_PerfFormattedData_MSSQLSERVER_SQLServerBufferNode	0	13	0	1	-	-	-

comments powered by Disqus