Node Configuration

Question

Experts,

Is there any best practice recommendation for mdop settings. Should it be equal to the number of numa node.

Answer 1

Hi Vishu-2318,
The MAXDOP option is related to number of processors and NUMA nodes.
Starting with SQL Server 2016 (13.x), use the following guidelines when you configure the max degree of parallelism server configuration value:

From SQL Server 2008 through SQL Server 2014 (12.x), use the following guidelines when you configure the max degree of parallelism server configuration value:

Best Regards
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Vishu ,

Did you have a look at the official Microsoft documentation about this?

Configure the max degree of parallelism Server Configuration Option
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-ver15

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Best regards,
Leon

Answer 3

I HIGHLY recommend against changing the default settings, unless you are having a problem. For the most part the default configuration, except for "Max server memory" works fine for 99% of workloads.

Answer 4

In addition to the other posts, I like to point out that you need to consider the type of workload for the server. For an strict OLTP workload with a lot of concurrent users, you want a lower value for MAXDOP than for a data warehouse where a few data analysts run some occasional, but wild, queries.