Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 causes 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
Microsoft Knowledge Base article 329204
Configure the max degree of parallelism Server Configuration Option