• 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.

    +1 to Grant's suggestion.  I've heard this same thing for years now and I have set CTFP to 50.  It did nothing but good things because almost everything didn't go parallel.