2.2 How Freeing the Plan Cache Reduces the Blast Radius: usp_PlanCacheAutopilot

If you monitor the plan cache looking for outliers, you can start to automate Identifying when a resource-intensive plan has gone into cache Saving the plan and its parameters for later analysis Freeing that plan from the cache automatically That’s where usp_PlanCacheAutopilot comes in. Let’s talk through how to use it: usp_PlanCacheAutopilot Script Normally I…

If you monitor the plan cache looking for outliers, you can start to automate Identifying when a resource-intensive plan has gone into cache Saving the plan and its parameters for later analysis Freeing that plan from the cache automatically That’s where usp_PlanCacheAutopilot comes in. Let’s talk through how to use it: usp_PlanCacheAutopilot Script Normally I...