Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
influent
Constraint Violating Yak Guru
367 Posts |
 Posted - 2014-07-17 : 15:27:28
|
| My main production server has four NUMA nodes with two SQL Server 2012 instances on it. One of the instances has the CPU affinity set to use only one NUMA node, and sys.dm_os_nodes reflects that correctly. The other instance has no affinity settings, so it should show all 4 NUMA nodes as online, I would think, but it shows Node 3 as offline, which happens to be the node that's online for the other instance. Is there a bug in SQL Server 11.0.3128 (Enterprise)? |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
|
|
|
|
|
NUMA node shown as offline without affinity set