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:
Soft NUMA is enabled, and the way I understand the output is there are 3 soft NUMA nodes.
However, when I query
Something further that is throwing me off is the results of this query of
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
I read the output as having 2 NUMA nodes, plus the one dedicated for admin connection (memory_node_id 64).

sys.dm_os_memory_clerks
:

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.

Asked by squillman
(1227 rep)
Jul 17, 2023, 02:52 PM
Last activity: Jul 17, 2023, 03:39 PM
Last activity: Jul 17, 2023, 03:39 PM