Do you have a link to the article, please? Our standard is as follows:
· 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.I would recommend you increase your cost threshold for parallelism to something between 30 and 50. The default of 5 is from a long time ago and based on very different hardware from what is available now
John
John , this is the link https://support.microsoft.com/en-in/help/2806535/recommendations-and-guidelines-for-the-max-degree-of-parallelism-confi
The NUMA config is left to its default as I checked ..