An important change to the MAXDOP documentation was made last week, with a good write up by Pedro Lopes (Twitter), a Program Manager on the SQL Server team at Microsoft. First though, some background on… MAXDOP: not quite what you think
(This post was updated on 5 February 2022). A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set cost threshold for parallelism to 50 Disable… Proposed SQL Server defaults: cost threshold for parallelism
(This post was updated on 5 February 2022.) Tempting headline, isn’t it? It might even seem like clickbait, but that’s not the intention. The SQL Server default configuration is not recommended for production environments, and… Fix SQL Server with one click