• salimdallal - Wednesday, August 30, 2017 1:47 PM

    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?

    For your research, here's a page where Paul posted how to query the plan cache.  https://www.sqlskills.com/blogs/jonathan/tuning-cost-threshold-for-parallelism-from-the-plan-cache/