Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryNode, ROOT\CIMV2

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

Description

This defines memory usage per NUMA node.

Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryNode properties

Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryNode has 15 properties (6 Local, 9 Derived)

Name	Origin	CIMType
Caption	CIM_StatisticalInformation	8 [string]
DatabaseNodeMemoryKB	Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryNode	21 [uint64]
Description	CIM_StatisticalInformation	8 [string]
ForeignNodeMemoryKB	Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryNode	21 [uint64]
FreeNodeMemoryKB	Win32_PerfFormattedData_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_PerfFormattedData_MSSQLSERVER_SQLServerMemoryNode	21 [uint64]
TargetNodeMemoryKB	Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryNode	21 [uint64]
Timestamp_Object	Win32_Perf	21 [uint64]
Timestamp_PerfTime	Win32_Perf	21 [uint64]
Timestamp_Sys100NS	Win32_Perf	21 [uint64]
TotalNodeMemoryKB	Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryNode	21 [uint64]

Detailed description of Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryNode properties

Local properties (6) of Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryNode class

▲ DatabaseNodeMemoryKB property
CIMTYPE	'uint64'
CookingType	'PERF_COUNTER_LARGE_RAWCOUNT'
Counter	'DatabaseNodeMemoryKB'
CounterType	65792
Description	'Amount of memory the server is using on this node for database pages.'
DisplayName	'Database Node Memory (KB)'
DisplayName009	'Database Node Memory (KB)'
HelpIndex	0
PerfIndex	0
PerfTimeFreq	'Frequency_PerfTime'
PerfTimeStamp	'Timestamp_PerfTime'
DatabaseNodeMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace

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

▲ FreeNodeMemoryKB property
CIMTYPE	'uint64'
CookingType	'PERF_COUNTER_LARGE_RAWCOUNT'
Counter	'FreeNodeMemoryKB'
CounterType	65792
Description	'Amount of memory the server is not using on this node.'
DisplayName	'Free Node Memory (KB)'
DisplayName009	'Free Node Memory (KB)'
HelpIndex	0
PerfIndex	0
PerfTimeFreq	'Frequency_PerfTime'
PerfTimeStamp	'Timestamp_PerfTime'
FreeNodeMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace

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

▲ TargetNodeMemoryKB property
CIMTYPE	'uint64'
CookingType	'PERF_COUNTER_LARGE_RAWCOUNT'
Counter	'TargetNodeMemoryKB'
CounterType	65792
Description	'Ideal amount of memory for this node.'
DisplayName	'Target Node Memory (KB)'
DisplayName009	'Target Node Memory (KB)'
HelpIndex	0
PerfIndex	0
PerfTimeFreq	'Frequency_PerfTime'
PerfTimeStamp	'Timestamp_PerfTime'
TargetNodeMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace

▲ TotalNodeMemoryKB property
CIMTYPE	'uint64'
CookingType	'PERF_COUNTER_LARGE_RAWCOUNT'
Counter	'TotalNodeMemoryKB'
CounterType	65792
Description	'Total amount of memory the server has committed on this node.'
DisplayName	'Total Node Memory (KB)'
DisplayName009	'Total Node Memory (KB)'
HelpIndex	0
PerfIndex	0
PerfTimeFreq	'Frequency_PerfTime'
PerfTimeStamp	'Timestamp_PerfTime'
TotalNodeMemoryKB property is in 4 classes of ROOT\cimv2 and in 1 namespace

Derived properties (9) of Win32_PerfFormattedData_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_PerfFormattedData_MSSQLSERVER_SQLServerMemoryNode Qualifiers

Name	Value	ToInstance	ToSubclass	Overridable	Amended	Local
AutoCook	1	✓	✗	✓	✗	✓
AutoCook_RawClass	'Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryNode'	✓	✗	✓	✗	✓
Cooked	True	✓	✗	✓	✗	✓
Description	'This defines memory usage per NUMA node.'	✓	✗	✓	✓	✓
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_PerfFormattedData_MSSQLSERVER_SQLServerMemoryNode System properties

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

Similar Classes to Win32_PerfFormattedData_MSSQLSERVER_SQLServerMemoryNode

Number of classes:1

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

comments powered by Disqus