0

This question already has an answer here:

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?

marked as duplicate by Shanky, Erik Darling, hot2use, McNets, Joe Obbish Feb 1 '18 at 1:43

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • 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? – Bhuvanesh Jan 31 '18 at 9:59
  • What was output when you run queries mentioned in the link ? – Shanky Jan 31 '18 at 10:04
  • I got the value 4 – Bhuvanesh Jan 31 '18 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 – Christian Gräfe Jan 31 '18 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. – Sean Gallardy Jan 31 '18 at 13:21
-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.