22-25 April 2026 
Accelerating Query Store data analysis with sp_QuickieStore
Proposed session for SQLBits 2026TL; DR
Learn how to troubleshoot performance issues faster using Query Store and the free sp_QuickieStore procedure, with practical demos you can apply immediately.
Session Details
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!
3 things you'll get out of this session
Use sp_QuickieStore to quickly identify high-impact performance issues.
Apply advanced filtering options to drill into specific problems faster.
Develop a faster, more effective performance troubleshooting workflow
Speakers
Cláudio Silva's other proposed sessions for 2026
Performance of a T-SQL query - The mystery, the investigation and the root cause! - 2026
dbatools - Wheel of Fortune - 2026
Cláudio Silva's previous sessions
Let me show you why data types still matter
Selecting the right data types is still important. Let's see some examples of why!
Writing T-SQL code for the engine, not for you "more demos" by popular demand
Often because of how quickly we want to write a T-SQL query we create more extra work for the engine.
People underestimate the power of rewriting a T-SQL query, but in the right cases, it will provide better performance.
Let's look at some scenarios where this is true!
Hear me out - Don't go offline because of your index deployment strategy
Want to avoid downtimes or big blocking operations when managing indexes on busy systems?
In this session, we will talk about some common problems that can lead to unexpected downtimes and how we could avoid them.
Lift and Shift with dbatools - Azure SQL Managed Instance edition
Migrating from On-Prem SQL Server to Azure SQL Managed Instance requires a set of pre-requirements that can become much easier if we can validate and repeat the steps needed.
No matter if it's an Offline or Online migration, dbatools can make your life easier.
Administrating SSRS without boring web based clicks
Automate SSRS management using Microsoft's PowerShell module