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 |
ID of the memory node. Related to memory_node_id of sys.dm_os_memory_clerks. |
virtual_address_space_reserved_kb |
bigint |
Number of virtual address reservations, in kilobytes (KB), that are neither committed nor mapped to physical pages. |
virtual_address_space_committed_kb |
bigint |
Amount of virtual address, in KB, that has been committed or mapped to physical pages. |
locked_page_allocations_kb |
bigint |
Amount of physical memory, in KB, that has been locked by SQL Server. |
single_pages_kb |
bigint |
Amount of committed memory, in KB, that is allocated by using the single page allocator by threads running on this node. This memory is allocated from the buffer pool. This value indicates the node where allocations request occurred, not the physical location where the allocation request was satisfied. |
multi_pages_kb |
bigint |
Amount of committed memory, in KB, that is allocated by using the multipage allocator by threads running on this node. This memory is from outside the buffer pool. This value indicates the node where the allocation requests occurred, not the physical location where the allocation request was satisfied. |
shared_memory_reserved_kb |
bigint |
Amount of shared memory, in KB, that has been reserved from this node. |
shared_memory_committed_kb |
bigint |
Amount of shared memory, in KB, that has been committed on this node. |
Permissions
Requires VIEW SERVER STATE permission on the server.