Juggler on a beach

MAXDOP: not quite what you think

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 parallelism. How do parallel queries work on SQL Server? SQL Server uses a costing algorithm to decide how “expensive” a
-> Continue reading MAXDOP: not quite what you think

Proposed SQL Server defaults: cost threshold for parallelism

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 lightweight pooling if it is enabled Disable priority boost if it is enabled Set optimize for ad hoc workloads to enabled Set max server memory (MB) to a
-> Continue reading Proposed SQL Server defaults: cost threshold for parallelism