The Microsoft SQL Server max degree of parallelism (MAXDOP) configuration option controls the number of processors that are used for the execution of a query in a parallel plan.
This topic has been discussed for many years, the best practices have changed more than once (see my old post about it –
Continue Reading rstefanetti’s Article on their blog
https://robertostefanettinavblog.com/2019/12/16/configure-maxdop-max-degree-of-parallelism-on-sql-server-2016-2019/
Blog Syndicated with rstefanetti’s Permission