2Fire (8/27/2014)
We are running SQL2012 with -2 physical processors 6 cores per processor 24 logical processors NUMA enabled - 2 nodes and 12 logical processors/node Per MSKB article - http://support.microsoft.com/kb/2806535
•For servers that have NUMA configured, MAXDOP should not exceed the number of CPUs that are assigned to each NUMA node.
•For servers that have hyperthreading enabled, the MAXDOP value should not exceed the number of physical processors.
•For servers that have NUMA configured and hyperthreading enabled, the MAXDOP value should not exceed number of physical processors per NUMA node.
This would indicate MAXDOP = 1.
Per a health audit performed on our SQL2008 server MAXDOP for NUMA architecture systems is to the number of physical cores in a single NUMA node.
That would indicate MAXDOP = 6.
I am confused! Can anyone recommend an appropriate MAXDOP setting for our configuration?
Quick thought, although MAXDOP does what it says on the tin (more or less), a better approach is to look at the cost threshold. There have been quite few drastic changes in the last two versions of SQL Server, almost prompts me to say "forget about the old stuff (2K8 and earlier)" kind of things.
😎