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