RE: CPU usage overhead after setting Max DOP

SSCertifiable

Points: 6345

August 31, 2017 at 7:48 am

#1957653

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.

Grant , is it suggested to change MAXDOP (with ref to Microsoft doc as well , based on the NUMA config) and CT for parallelism as a unanimous opinion , or there are any other areas to be considered for dependencies ? Thank you.