a coffee filtering process

Don’t optimize for ad hoc workloads as a best practice

(This post was co-authored by Erik Darling.) The more things stay the same, the more they change… No, that’s not a mistake. In fact, it’s a reference to long-held belief systems that don’t take new information into account, and how confirmation bias is not a good motivator for recommending best practices. Let’s talk about the
-> Continue reading Don’t optimize for ad hoc workloads as a best practice

Proposed SQL Server defaults: optimize for ad hoc workloads

(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 lightweight pooling if it is enabled Disable priority boost if it is enabled Set optimize for ad hoc workloads to
-> Continue reading Proposed SQL Server defaults: optimize for ad hoc workloads