Max Degree of Parallelism (MAXDOP) is a configuration option that determines the maximum number of threads dispatched by SQL Server to service queries that might benefit from parallel operation.
6
votes
3answers
589 views
What is a good, repeatable way to calculate MAXDOP on SQL Server?
When setting up a new SQL Server 2012, I use the following code to determine a good starting point for the MAXDOP setting:
/*
This will recommend a MAXDOP setting appropriate for your machine's ...
