I have three IBM x3950 M2.
Each IBM have four physical CPUs and each CPUs have 6 cores with 48GB of memory.
They are merged together so I have a host with 12 CPUs (72 Logical) and 144GB of memory.
I'm running Windows Server 2008 R2 Datacenter without any problem, my three NUMA nodes are detected.
The problem is with SQL Server 2008 Enterprise. It detect only 48 CPUs instead of the 72. The memory is detected correclty SQL report the 144GB.
In the ERRORLOG file I have:
Detected 48 CPUs. This is an informational message....
Node configuration: node 0: CPU mask: 0x0000ffffff000000 Active CPU mask: 0x0000ffffff000000.
Node configuration: node 1: CPU mask: 0x0000000000ffffff Active CPU mask: 0x0000000000ffffff.
From the view sys.dm_os_nodes
I only have two nodes reported has online each report
. I have a third node but it's for the DAC.
Since Windows is able to detect all CPUs I don't understand why SQL Server is not able to detect them.
So my question is how can I setup SQL Server to detect all my CPUs?
View Complete Post