TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Set the Max Degree of Parallelism Option for Optimal Performance

 

Applies To: SQL Server 2016

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.

Microsoft Knowledge Base article 329204

Configure the max degree of parallelism Server Configuration Option

sp_configure (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft