On the SWYNK mailing list, Linchi and Cindy were taking about MAXDOP when Cindy mentioned the NUMA best practice. I did a quick google hoping it was documented to make it easier to persuade customers and badda bing...
Use the following guidelines when you configure the MAXDOP value:
• For servers that use more than eight processors, use the following configuration: MAXDOP=8.
• For servers that have eight or less processors, use the following configuration where N equals the number of processors: MAXDOP=0 toN.
• 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 hyper-threading enabled, the MAXDOP value should not exceed the number of physical processors.
Name (required)
Email (required)
Website
Notify me of followup comments via e-mail