Optimize for Ad Hoc Workloads
The Optimize for Ad Hoc Workloads server configuration can improve performance, and is extremely unlikely to negatively impact performance. This was a new feature that was introduced in SQL Server 2008, and as with many new features in SQL Server, it is not turned on by default. What Optimize for Ad Hoc Workloads Changes. Without the Optimize for Ad Hoc …