This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi all,
I found on a server MAX degree of parallelism a 2 as value.
SQL Server detected 4 sockets with 4 cores per socket and 4 logical processors per socket, 16 total logical processors; using 16 logical processors based on SQL Server licensing.
I thought 4 was the correct value.. I would like confirmation.
Thanks ALEN
For this reason I said 4, but correct me if I make a mistake.
| Server with single NUMA node | Less than or equal to eight logical processors | Keep MAXDOP at or below # of logical processors |
| Server with single NUMA node | Greater than eight logical processors | Keep MAXDOP at 8 |
| Server with multiple NUMA nodes | Less than or equal to 16 logical processors per NUMA node | Keep MAXDOP at or below # of logical processors per NUMA node |
| Server with multiple NUMA nodes | Greater than 16 logical processors per NUMA node | Keep MAXDOP at half the number of logical processors per NUMA node with a MAX value of 16 |
The "correct" value for "MAX degree of parallelism" depends on your workload. Both 2 and 4 MAXDOP settings are within the "Keep MAXDOP at or below # of logical processors per NUMA node" recommendation.
I suggest the lower setting on servers with a highly transactional OLTP workload to help mitigate the potential impact parallel reporting type queries might have on the more critical transactional workload.