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…
To access this incredible, amazing content, you gotta get Mastering Parameter Sniffing – Live Classes + Instant Replay, 1 Year Access, Mastering Parameter Sniffing – Instant Replay Recordings Only, 1 Year Access or Recorded Class Season Pass, or log in if you already shelled out the cash.
Hi! I’m Brent Ozar.
I make Microsoft SQL Server go faster. I love teaching, travel, cars, and laughing. I’m based out of Las Vegas. He/him. I teach SQL Server training classes, or if you haven’t got time for the pain, I’m available for consulting too.
Want to advertise here and reach my savvy readers?