Inconsistent result for NUMA node memory usage in SQL Server

1 vote

1 answer

261 views

                          Regarding the query below which I run on a physical server with SQL Server 2019:

    SELECT
        memory_node_id,
        SUM(pages_kb) / 1024.0/1024 AS TotalMemoryGB
    FROM sys.dm_os_memory_clerks
    GROUP BY memory_node_id
    ORDER BY memory_node_id;

for memory_node_id = 0 it shows more memory than physically available on the NUMA node. How can that be? 

                        

Asked by xhr489 (827 rep)

Jul 3, 2024, 12:59 PM
Last activity: Jul 3, 2024, 01:25 PM

Inconsistent result for NUMA node memory usage in SQL Server

Related Questions