Database scoped optimizing for ad hoc workloads

added by DotNetKicks
1/4/2018 5:59:51 PM


SQL Server provides the " optimize for ad hoc workloads " server-scoped option that is used to reduce the memory footprint of single use ad hoc batches and associated plans. When enabled at the SQL Server instance scope, the "optimize for ad hoc workloads" option stores a reduced-memory compiled plan stub on the first execution of an ad hoc batch for any database on the instance.