Cached Out
There are lots of examples of how to do this with the plan cache, but, well, the plan cache can be an awfully unstable place.
Query store being a bit more historically reliable, we can use some of …
Category: Query Store
Finding Single Use Queries In Query Store
Caching The Line
This metric gets looked at a lot in the plan cache to see how effective it is. The main problem is that with high enough churn, you might not catch all the queries involved in the problem. …
sp_QuickieStore Improved Performance Troubleshooting
Things Are Getting Better
…
sp_QuickieStore Debugging
Centipede
Thanks for watching!…
sp_QuickieStore Passing Lists
Checking It Twice
Thanks for watching!…
sp_QuickieStore Performance Trouble Shooting
Four Hours
Thanks for watching!…
sp_QuickieStore Error Handling
Red Text
Thanks for watching!…
sp_QuickieStore: Safe Dynamic SQL
Headboard
Thanks for watching!…
Introducing sp_QuickieStore: What To Do If You Hit A Problem
No One’s Perfect
I’ve been working on scripts like this for long enough to know that I don’t know everything that might happen out there in your kooky-krazy environments.
The beauty of open source is that it’s really easy to …
Introducing sp_QuickieStore: Formatting Is Everything
Random Assortment
Sometimes it’s hard to get people to understand the scale of a number without some commas.
I don’t know why that is, but that’s why I added the option to format numbers.
You can do that by running …