There are recommendations for setting max degree of parallelism (MAXDOP) in SQL Server based on Microsoft standards.
SQL performance can be impacted if the configuration is not setup for optimal parallel processing.
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 |