Set Max Degree of Parallelism Option for Optimal Performance (SQL Server BPA)

  • Article

This rule determines whether the max degree of parallelism (MAXDOP) option for a value greater than 8. Setting this option to a larger value often results in unwanted resource consumption and performance degradation.

Best Practices Recommendations

Set the max degree of parallelism option to 8 or less by using sp_configure.

For More Information

General Guidelines to Configure the MAXDOP Option

max

Parallel Query Processing