Max Degree of Parallelism

Question

Max Degree of Parallelism

sharon-472085

Ten Centuries

Points: 1182
More actions
August 9, 2018 at 9:27 am

#414879

HI ,
I NEED HELP T CONFIGURE Max Degree of Parallelism
with best prectice configutarion from os:
i have :
1 nume socket ( 2.4 gh)
12 cores
24 logical proccesor
from SQL :
SELECT cpu_count,*
FROM [sys].[dm_os_sys_info]=24
I GET VALUE 24
what velua will bee good and correct for Max Degree of Parallelism .
thank you vary much for helping
sql 2017 standard edition
sharon

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

Here's the recommendation from Microsoft
https://support.microsoft.com/en-us/help/2806535/recommendations-and-guidelines-for-the-max-degree-of-parallelism-confi

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Luis Cazares SSC Guru Points: 183706 More actions · Answer 2

Some other sources:
https://www.brentozar.com/archive/2013/09/five-sql-server-settings-to-change/
https://www.mssqltips.com/sqlservertip/2650/what-maxdop-setting-should-be-used-for-sql-server/

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

Eirikur Eiriksson SSC Guru Points: 182915 More actions · Answer 3

sharon-472085 - Thursday, August 9, 2018 9:27 AM
HI ,
I NEED HELP T CONFIGURE Max Degree of Parallelism
with best prectice configutarion from os:
i have :
1 nume socket ( 2.4 gh)
12 cores
24 logical proccesor
from SQL :
SELECT cpu_count,*
FROM [sys].[dm_os_sys_info]=24
I GET VALUE 24
what velua will bee good and correct for Max Degree of Parallelism .
thank you vary much for helping
sql 2017 standard edition
sharon

Quick question, have you checked / set the value for the parallelism cost threshold?
😎

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 4

I can't speak for anyone else but I've had great success in setting maxdop so than no one process can use more than 25% of the CPUs available and then, like the MS recommendation, if that number is larger than 8, is use the number 8.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)