cryovenom (3/15/2013)
This may sound like a rather basic question, but what do you mean by "you've mixed NUMA nodes in your settings"? Can two instances not use cores in the same NUMA node? or can one instance not use cores in separate NUMA nodes? I noticed that in 2012 it separated my cores into 4 nodes, while 2008 didn't do that, but I didn't realize there were things I couldn't split across nodes.
If you only have 2 nodes in 2008 you have different hardware. While the 2012 SQLOS memory manager was rewritten, the NUMA layout presented is from the hardware and SQLOS creates memory nodes that map to the hardware nodes directly, so you have to have different configurations for hardware.
I was setting them in SSMS. The only reason that chunk of SQL using sp_configure 'affinity mask' appears there is because that's what I found when I was looking for a way to un-do the setting without an uninstall/reinstall of the instance. I'm assuming SSMS uses ALTER SERVER CONFIGURATION behind the scenes to set things.
That is a dangerous and incorrect assumption. Just because SSMS does something one way doesn't mean that is the best, or even correct, way of doing things.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]