sys.dm_os_memory_nodes (Transact-SQL)
Allocations that are internal to SQL Server use the SQL Server memory manager. Tracking the difference between process memory counters from sys.dm_os_process_memory and internal counters can indicate memory use from external components in the SQL Server memory space.
Nodes are created per physical NUMA memory nodes. These might be different from the CPU nodes in sys.dm_os_nodes.
No allocations done directly through Windows memory allocations routines are tracked. The following table provides information about memory allocations done only by using SQL Server memory manager interfaces.
Column name |
Data type |
Description |
|---|---|---|
memory_node_id |
smallint |
Specifies the ID of the memory node. Related to memory_node_id of sys.dm_os_memory_clerks. Not nullable. |
virtual_address_space_reserved_kb |
bigint |
Indicates the number of virtual address reservations, in kilobytes (KB), which are neither committed nor mapped to physical pages. Not nullable. |
virtual_address_space_committed_kb |
bigint |
Specifies the amount of virtual address, in KB, that has been committed or mapped to physical pages. Not nullable. |
locked_page_allocations_kb |
bigint |
Specifies the amount of physical memory, in KB, that has been locked by SQL Server. Not nullable. |
pages_kb |
bigint |
Specifies the amount of committed memory, in KB, which is allocated from this NUMA node by Memory Manager Page Allocator. Not nullable. |
shared_memory_reserved_kb |
bigint |
Specifies the amount of shared memory, in KB, that has been reserved from this node. Not nullable. |
shared_memory_committed_kb |
bigint |
Specifies the amount of shared memory, in KB, that has been committed on this node. Not nullable. |
cpu_affinity_mask |
bigint |
Internal use only. Not nullable. |
online_scheduler_mask |
bigint |
Internal use only. Not nullable. |
processor_group |
smallint |
Internal use only. Not nullable. |
foreign_committed_kb |
bigint |
Specifies the amount of committed memory, in KB, from other memory nodes. Not nullable. |
Permissions
Requires VIEW SERVER STATE permission on the server.
Compatibility Support
In SQL Server 2012, the following columns have been renamed.
Previous Column Name |
New Column Name |
|---|---|
single_pages_kb |
pages_kb |
multi_pages_kb |
foreign_committed_kb |
See Also
Reference
Dynamic Management Views and Functions (Transact-SQL)
SQL Server Operating System Related Dynamic Management Views (Transact-SQL)