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.