Set the Max Degree of Parallelism Option for Optimal Performance
Collapse the table of content
Expand the table of content

Set the Max Degree of Parallelism Option for Optimal Performance

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.

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

Community Additions

ADD
Show:
© 2016 Microsoft