Nejčastěji odpovídající uživatel
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?
WHERE TYPE = 'MEMORYCLERK_SQLBUFFERPOOL';
Can anyone please give any hint? Thanks.
Hope the below links will help
SQL Server Setup Team
This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
This can be beneficial to other community members reading the thread.