22-25 April 2026 
Cláudio Silva
claudioessilva.eu
SQL Server DBA and PowerShell lover to automate any process that needs to be done more than a couple of times.
Video unavailable
SQLBits 2026
Accelerating Query Store data analysis with sp_QuickieStore
Learn how to troubleshoot performance issues faster using Query Store and the free sp_QuickieStore procedure, with practical demos you can apply immediately.
Query Store has been around since SQL Server 2016, and since then, it's been an essential tool for analysing either 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 quickly answer real-world performance problems, including how to:
- 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-life and 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!
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 quickly answer real-world performance problems, including how to:
- 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-life and 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!