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

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, Jan 31 '18 at 09:59
What was output when you run queries mentioned in the link ? — Shanky, Jan 31 '18 at 10:04
Then start with 4 even I would have started with 4 because there are 4 cores. Also note that the value is not absolute but almost correct. — Shanky, Jan 31 '18 at 10:08
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, Jan 31 '18 at 10:10
The DBAtools returns 8, So I have no NUMA but I have 1 socket. (My windows server is in AWS - Virtualized). So how SQL consider this as a NUMA ? — TheDataGuy, Jan 31 '18 at 10:15
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, Jan 31 '18 at 13:21
Post the output of COREINFO.exe as I described in (https://dba.stackexchange.com/a/36578/8783) — Kin Shah, Jan 31 '18 at 14:52

score -1 · Answer 1 · answered Jan 31 '18 at 13:21

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 Answers1