Search Results for “sp_blitz”

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…