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

Question

Im using a SQL Server with the below configurations.

I read this Doc:

Since I don't have NUMA and HyperThread.

So what could be my best MAXDOP setting?

I saw this post already, even the microsoft link which I added in the question is telling the answer for that. But my question is I don't have NUMA support so what could be the best value? — TheDataGuy, Commented Jan 31, 2018 at 9:59
What was output when you run queries mentioned in the link ? — Shanky, Commented Jan 31, 2018 at 10:04
You could try the PowerShell module dbatools. There is a command to test your MaxDop settings for the whole instance or per database Import-Module dbatools Test-DbaMaxDop -SqlInstance localhost\SQL2017 — Christian Gräfe, Commented Jan 31, 2018 at 10:10
You can't have 4 cores and 8 logical threads without hyperthreading, fyi. You either have a full core (execution unit) or you don't. 8 execution units would be 8 full cores. — Sean Gallardy, Commented Jan 31, 2018 at 13:21

LBooij · Accepted Answer · 2018-01-31 13:21:39Z

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

1 Answer 1