What is the MAXDOP value for the server which doesn't have NUMA

Question

Im using a SQL Server with the below configurations.

• 4 Core.
• 8 Logical processors.
• No NUMA.
• NO hyperthreading.

I read this Doc:

Recommendations and guidelines for the "max degree of parallelism" configuration option in SQL Server

Since I don't have NUMA and HyperThread.

So what could be my best MAXDOP setting?

Answer 1

For SQL Server 2005 and later versions

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

See : Recommendations and guidelines for the "max degree of parallelism" configuration option in SQL Server