How many cores does a soft NUMA have?
When the detected number of physical cores is more than eight per socket, the SQL Server Database Engine creates soft-NUMA nodes that ideally contain eight cores, but can go down to five or up to nine logical cores per node.
What is the CPU mask for NUMA server?
This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required. 2016-11-14 13:39:43.63 Server Node configuration: node 1: CPU mask: 0x0000000000aaaaaa:0 Active CPU mask: 0x0000000000aaaaaa:0.
Is there CPU affinity masking on SQL Server?
On the VM, only half of the CPUs were 100% while the others were less than 20%. We checked to make sure there was no CPU Affinity Masking assigned and even tried adjusting the “max degree of parallelism” to make sure there was no MAXDOP hints on the queries.
Where to find Numa configuration information in SQL Server?
When SQL Server starts up is outputs the NUMA information in the error log detailing its view of NUMA and provides DMV outputs to show the information as well. Here is the output from my 2 Processor Group system. A NUMA node can’t span a processor group so I am assured to have 2 NUMA nodes with CPUs associated with each node.
What are the registry values for soft Numa?
When using this method, the soft-NUMA mask can be stated as a binary, DWORD (hexadecimal or decimal), or QWORD (hexadecimal or decimal) registry entry. To configure more than the first 32 CPUs use QWORD or BINARY registry values (QWORD values cannot be used prior to SQL Server 2012 (11.x)).
When to create soft NUMA nodes in SQL Server?
With SQL Server 2016 (13.x), whenever the SQL Server Database Engine detects more than eight physical cores per NUMA node or socket at startup, soft-NUMA nodes are created automatically by default. Hyper-threaded processor cores are not differentiated when counting physical cores in a node.