I was going through MS documentation reg: setting MAXDOP starting SQL2016 as that Automatic soft NUMA enabled by default and getting confused on how to make the changes to current SQ2014 and SQL2012 versions:
MSDN link-- https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-degree-of-parallelism-server-configuration-option?view=sql-server-2017#Guidelines
Current SQL2012/2014 setup:
Logically Processors =80 Numa Node=4 Physical RAM= 512GB MAXDOP=8 and CTOP=5 HyperThreading enabled ='True'
So whats the change after moving them to SQL2016 and above? Will MAXDOP of current setup does not hold any more and needs to tune ? if yes what is MS proposing?
Please share your experiences on setting this up.