0

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?

9
  • 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, 2018 at 9:59
  • What was output when you run queries mentioned in the link ?
    – Shanky
    Jan 31, 2018 at 10:04
  • I got the value 4
    – TheDataGuy
    Jan 31, 2018 at 10:06
  • 3
    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 Jan 31, 2018 at 10:10
  • 1
    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. Jan 31, 2018 at 13:21

1 Answer 1

-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

Not the answer you're looking for? Browse other questions tagged or ask your own question.