Using Recommendations for MAXDOP and Max Memory During Installation


Finally, two important SQL Server recommended settings have been introduced during the installation process. These are the settings that every DBA (should) change after every single installation. The settings are MaxDOP and Max Memory. This article looks at each of these settings and how they are presented during installation.

MaxDOP

When an instance of SQL Server runs on a computer that has more than one CPU logical core, it detects the best degree of parallelism for a query. That is to say, the number of processors employed to run a single task for each part of a parallel plan execution.