Wow… We have MAXDOP calculator for SQL Server… It makes my job easier…

So after Max. Server Memory calculator, to make your life much more easier, here is the Max Degree of Parallelism or MAXDOP calculator. We are using SQL DMV’s to find out the number of NUMA nodes and Powershell query to find out the number of processor cores and then use the recommendations given in http://support.microsoft.com/kb/2023536 to give a MAXDOP value…

11