Max Degree of Parallelism

The max degree of parallelism (MAXDOP) configuration option limits how many processors can be used during the execution of a query. Having the setting too low can limit SQL Server's ability to benefit from running queries over multiple processors, but having it set too high can cause problems with CPU contention. Other factors include MAXDOP set at a database level, resource governors, and the MAXDOP query hint.

Suggested Action

We've used the guidelines from the Microsoft Support article, KB2806535.

Any suggestion from Aireforge should be thoroughly tested before being implemented into production.

Further Reading

Recommendations and guidelines for the "max degree of parallelism" configuration option in SQL Server | Microsoft KB2806535