Environment
- App Control Server: All Versions
- MS SQL Server
Question
Are there recommendations for setting max degree of parallelism (MAXDOP) in SQL Server?
Answer
Use the following guidelines when configuring the max degree of parallelism (MAXDOP) server configuration value:
NUMA nodes
|
Logical Processors
|
MAXDOP recommendation
|
Server with single NUMA node
|
Less than 8 logical processors
|
Keep MAXDOP at or below # of logical processors
|
Server with single NUMA node
|
Greater than 8 logical processors
|
Keep MAXDOP at 8
|
Server with multiple NUMA nodes
|
Less than 8 logical processors per NUMA node
|
Keep MAXDOP at or below # of logical processors per NUMA node
|
Server with multiple NUMA nodes
|
Greater than 8 logical processors per NUMA node
|
Keep MAXDOP at 8
|
Additional Notes