Sample Header Ad - 728x90

Can you help clarify my server's NUMA configuration?

1 vote
0 answers
329 views
I have a SQL Server 2022 Enterprise instance in a VMWare VM. We upgraded this instance last week from Standard to Enterprise and I want to now make sure we use the appropriate instance level setting for MAXDOP. The VM has a single NUMA node (NUMA Nodes is grayed out in Task Manager|CPU). The SQL Server log shows this: enter image description here Soft NUMA is enabled, and the way I understand the output is there are 3 soft NUMA nodes. However, when I query sys.dm_os_memory_nodes I read the output as having 2 NUMA nodes, plus the one dedicated for admin connection (memory_node_id 64). enter image description here Something further that is throwing me off is the results of this query of sys.dm_os_memory_clerks: enter image description here Can someone help me to confirm how many nodes I actually have? Are the log output and the results of sys.dm_os_memory_nodes giving me what I want, and I have 2 nodes plus the dedicated admin connection? If that's the case, what is the query from sys.dm_os_memory_clerks telling me? **EDIT:** Here is the output of sys.dm_os_nodes as requested. enter image description here
Asked by squillman (1227 rep)
Jul 17, 2023, 02:52 PM
Last activity: Jul 17, 2023, 03:39 PM