Query Store has been available since SQL Server 2016, and has since been an essential tool for analysing live or past performance issues.
Microsoft provides several dashboards in SSMS to help analyse Query Store data, but they can be slow and offer limited filtering options, making it hard to narrow down your search and find what you need.

Enter "sp_QuickieStore" by Erik Darling. This free SQL Server stored procedure can help us get the most out of Query Store data.

In this session, we'll look at how to install and use sp_QuickieStore to answer real-world performance problems, including how to quickly:
- Search for aborted or timed-out queries
- Filter by different properties like: plan_id, query_hash, module, and more
- Search across all databases, or include/exclude only the ones you need

This will be a demo-heavy session focused on real-world, practical examples that you can use immediately!
Whether you're a DBA, developer, or accidental performance tuner, you'll walk away with another tool and new approaches to tackle your performance problems!