Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

App Control: Are There Recommendations for Setting MAXDOP in SQL Server?

App Control: Are There Recommendations for Setting MAXDOP in SQL Server?

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


Labels (1)
Tags (2)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎03-30-2021
Views:
334