August 9, 2013 at 6:50 am
I know this is a very subjective topic and the actual figured is best gained through testing etc but I just wanted to ask if there is any truth to the following:
ideal maxdop = total cores / number of NUMA nodes * 0.75
I have found this formula in a few places but havent found with it any explanation or reasons how it works, could anyone explain?
'Only he who wanders finds new paths'
August 9, 2013 at 8:38 am
I've seen other recommendations that say maxdop = number of numa nodes, but even that was caveated by knowing if your system was OLTP or OLAP. I spent quite a long time testing a combination of maxdop and cost threshold for parallelism options before coming up with a configuration quite a long way from the thumb-in-the-air recommendation
August 10, 2013 at 8:50 am
I personally recommend a maxdop max value of the number of PHYSICAL CORES in each NUMA node. Go down from there if necessary.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy