How “Optimize for Adhoc Workload” impacts your Plan Cache

Today I want to talk about the server option Optimize for Adhoc Workload and how it affects your Plan Cache in SQL Server. Before we dig into the details, I want to show you how SQL Server can reuse cached execution plans. Execution Plan Reuse Every time that you submit a query to SQL Server, …

How “Optimize for Adhoc Workload” impacts your Plan Cache + read more