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: Query Store
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, …
How SQL Server 2022’s Parameter Sensitive Plan Feature Can Make Query Store Confusing
Psssssp
Thanks for watching!
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m …
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,
SQL Server 2022: Cardinality Estimation Feedback
Quiet As Kept
I’ve been trying to take the general temperature when it comes to SQL Server 2022. At least from a performance perspective, some interesting things have been introduced so far.
There have been a few neat things:
- Parameter