I am a heading
Over the past month (plus or minus a couple days), I’ve shown you in a series of quick posts how I use different SQL Server Community Tools that are free and open source to troubleshoot SQL …
Category: sp_QuickieStore
SQL Server Community Tools: How To Dig Deeper With Expert Mode With sp_QuickieStore
Perfect Crime
As much as I’d love to think that the normal set of results in sp_QuickieStore is sufficient, sometimes you need a little bit more to figure out what’s going on.
That’s where Expert Mode comes in. Or, as …
SQL Server Community Tools: Formatting sp_QuickieStore Output So It’s Easier To Understand
Scaling
I am not great at numbers. Especially big numbers, or numbers that need to get converted, like going from KB to GB.
Not KGB. I don’t wanna ever end up there.
Being but a mere mortal, I always find …
SQL Server Community Tools: How To Find Specific Queries With sp_QuickieStore
Stinky And Gross
Query Store gives you no way to really search through it. There are knobs and you can filter to specific times and stuff, but… That’s not really helpful most of the time.
If you need to find …
SQL Server Community Tools: How To Filter What sp_QuickieStore Shows You
Wide Open
I try not to make too many assumptions about what you might want to see. The only real restrictions out of the box with sp_QuickieStore are:
- It only looks at one database at a time
- It only shows
SQL Server Community Tools: Using sp_QuickieStore To Find Your Worst Performing Queries
Mind Loss
Microsoft has invested some engineering time in the plumbing behind Query Store in SQL Server 2022. Really cool stuff, like the ability to add hints to a query and force it to use the plan with that hint …
Correlating Data From sp_WhoIsActive to Query Store Or The Plan Cache
sp_QuickiePost
If you’re the type of person who logs sp_WhoIsActive to a table to capture executing queries, you may want to find some additional details about the statements that end up there.
Out of the box, it’s arduous, tedious, …
Let’s Stop Calling Queries “Expensive”
Bad Names
When we talk about finding queries to tune, there’s an unfortunate term that gets thrown around: Expensive Queries.
Why is it unfortunate? Well, it reinforces the wrong mindset when it comes to query tuning, and leads people down …
Updates to sp_QuickieStore
Just Visiting
I made some updates to sp_QuickieStore recently, which you can download here.
The main updates to the code are to:
- Add support for SQL Server 2022 views
- Add the ability to search by query hash, plan hash,
Updates To sp_HumanEvents, sp_QuickieStore, And More!
For Free!
Here’s some stuff I’ve been working on lately:
- Added an inline table valued function that strips characters from a string
- Added a script to create useful Alerts in SQL Server
- Added the recompile_cause column to the