Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode, ROOT\CIMV2

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

Description

This defines memory usage per NUMA node.

Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode properties

Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode has 15 properties (6 Local, 9 Derived)

Name	Origin	CIMType
Caption	CIM_StatisticalInformation	8 [string]
DatabaseNodeMemoryKB	Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode	21 [uint64]
Description	CIM_StatisticalInformation	8 [string]
ForeignNodeMemoryKB	Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode	21 [uint64]
FreeNodeMemoryKB	Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode	21 [uint64]
Frequency_Object	Win32_Perf	21 [uint64]
Frequency_PerfTime	Win32_Perf	21 [uint64]
Frequency_Sys100NS	Win32_Perf	21 [uint64]
key Name	CIM_StatisticalInformation	8 [string]
StolenNodeMemoryKB	Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode	21 [uint64]
TargetNodeMemoryKB	Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode	21 [uint64]
Timestamp_Object	Win32_Perf	21 [uint64]
Timestamp_PerfTime	Win32_Perf	21 [uint64]
Timestamp_Sys100NS	Win32_Perf	21 [uint64]
TotalNodeMemoryKB	Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode	21 [uint64]

Detailed description of Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode properties

Local properties (6) of Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode class

▲ DatabaseNodeMemoryKB property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	-4
Description	'Amount of memory the server is using on this node for database pages.'
DetailLevel	100
DisplayName	'Database Node Memory (KB)'
DisplayName009	'Database Node Memory (KB)'
HelpIndex	0
PerfDefault	True
PerfIndex	0
DatabaseNodeMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ ForeignNodeMemoryKB property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	-4
Description	'Non NUMA-local amount of memory on this node.'
DetailLevel	100
DisplayName	'Foreign Node Memory (KB)'
DisplayName009	'Foreign Node Memory (KB)'
HelpIndex	0
PerfIndex	0
ForeignNodeMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ FreeNodeMemoryKB property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	-4
Description	'Amount of memory the server is not using on this node.'
DetailLevel	100
DisplayName	'Free Node Memory (KB)'
DisplayName009	'Free Node Memory (KB)'
HelpIndex	0
PerfIndex	0
FreeNodeMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ StolenNodeMemoryKB property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	-4
Description	'Amount of memory the server is using on this node for the purposes other than database pages.'
DetailLevel	100
DisplayName	'Stolen Node Memory (KB)'
DisplayName009	'Stolen Node Memory (KB)'
HelpIndex	0
PerfIndex	0
StolenNodeMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ TargetNodeMemoryKB property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	-4
Description	'Ideal amount of memory for this node.'
DetailLevel	100
DisplayName	'Target Node Memory (KB)'
DisplayName009	'Target Node Memory (KB)'
HelpIndex	0
PerfIndex	0
TargetNodeMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ TotalNodeMemoryKB property
CIMTYPE	'uint64'
CounterType	65792
DefaultScale	-4
Description	'Total amount of memory the server has committed on this node.'
DetailLevel	100
DisplayName	'Total Node Memory (KB)'
DisplayName009	'Total Node Memory (KB)'
HelpIndex	0
PerfIndex	0
TotalNodeMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode 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_SQLServerMemoryNode Qualifiers

Name	Value	ToInstance	ToSubclass	Overridable	Amended	Local
Description	'This defines memory usage per NUMA node.'	✓	✗	✓	✓	✓
DetailLevel	100	✓	✗	✓	✗	✓
DisplayName	'SQLServer:Memory Node'	✓	✗	✓	✓	✓
DisplayName009	'SQLServer:Memory Node'	✓	✗	✓	✗	✓
dynamic	True	✓	✗	✓	✗	✓
GenericPerfCtr	True	✓	✗	✓	✗	✓
HelpIndex	0	✓	✗	✓	✗	✓
HiPerf	True	✓	✗	✓	✗	✓
Locale	1033	✓	✗	✓	✓	✓
PerfIndex	0	✓	✗	✓	✗	✓
provider	'WmiPerfInst'	✗	✗	✓	✗	✓
RegistryKey	'MSSQLSERVER'	✓	✗	✓	✗	✓

Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode System properties

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

Similar Classes to Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode

Number of classes:1

Class name	Childs	Properties	Methods	Class Instances	Child Instances	Abstract	Singleton
Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryNode	0	15	0	1	-	-	-

comments powered by Disqus