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?

  • Interesting. Maybe with the licencing revamp they locked things down to the number of CPUs in Windows so you can only use each one in one instance. What happens if you shut down the instance assigned one NUMA node, and then start up or restart the other instance? Does it still use 3, or does it now use 4? – Jon Seigel Jul 17 '14 at 1:27
  • What edition of SQL Server are you using? – Sean Gallardy - Retired User Jul 17 '14 at 12:31
  • @Jon: this is a 24x7 prod server so I can't test that for a couple weeks. – influent Jul 17 '14 at 18:50
  • @Sean: Enterprise – influent Jul 17 '14 at 18:51

Found the answer: http://blogs.msdn.com/b/sql_shep/archive/2012/06/21/sql-server-2012-license-core-limitaion.aspx

My consultants installed the wrong version (CAL instead of core), so it's limited to 20 cores.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.