Igor Micev (3/27/2015)
If you're going to play with MAXDOP, the figure I use (based on advice from Adam Machanic) is 1.5*(number of physical cores in a NUMA node).
I'm curious to see that advise and some experiments for it. Is there a link somewhere? I couldn't find it. Thanks.
It was based on a discussion that we had, he hasn't, to my knowledge, blogged it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability