Strange Things Are Afoot
I use sp_QuickieStore to dig into Query Store data to find queries to tune. I wrote it because I was often unhappy when dealing with the GUI.
You can download it here. Remember to check back for updates, or star/follow my repo to get notifications about them.
There’s a whole bunch of posts I wrote about how to use it:
- Find Your Worst Queries In Query Store
- What The Results Show You
- What You Can Filter
- Formatting Is Everything
- What To Do If You Hit A Problem
There’s also a playlist of videos that walk through the code and some of the output here:
Again, you can download it here and also use GitHub to report bugs or feature requests.
Just don’t request bugs.