SQL Server – Determine MAXDOP settings

Download Sysinternals zip file Coreinfo. This explains how to use it.

Here is how we got into this mess:

• Recommendations and guidelines for the “max degree of parallelism” configuration option in SQL Server
• And Here
• and Brent