Grant Fritchey - Wednesday, August 30, 2017 8:54 AM
In addition to MAXDOP, it's a good idea to set the Cost Threshold for Parallelism to a higher value than the default of 5. Out of the box. You'll see fewer plans going parallel unnecessarily if you make that adjustment.
I don't have much experience there but i'll give do some research on this value. But from your experience have setting Max DOP caused an increase in average CPU consumption of SQL machine?