Proposed SQL Server defaults: max server memory

, 2019-05-15

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: max server memory

The post Proposed SQL Server defaults: max server memory appeared first on Born SQL.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

Share

Share

Rate