How to Configure NUMA Node Memory Allocation?


  • We have a server with two hardware NUMA nodes. The SQL Server 2008 R2 SP1 was installed with default settings. What I found by running the following query is that it seems only Node 1 is reserving all the VAS (128GB); where Node 0 reserves nothing. And there is also a third node - Node 64, I don't know what that is for. From what I have read, memory should be evenly distributed to all the online nodes, isn't it?

    SELECT *
    FROM sys.dm_os_memory_clerks

    Can anyone please give any hint? Thanks.

    26. dubna 2012 23:32


Všechny reakce