Stop Guessing: Solve SQL Performance Problems with Query Store

Data Engineers in Toronto July 2026 Semimonthly Meeting

Topic: Stop Guessing: Solve SQL Performance Problems with Query Store

Abstract:

When query performance suddenly changes, finding the root cause isn't always easy. Execution plans can change over time, and the plan cache often provides only a limited view of what happened.

Query Store helps by capturing query history, execution plans, and runtime statistics, giving you the visibility needed to identify regressions, compare plans, and maintain consistent performance.

In this session, you'll learn how to use Query Store to monitor query behavior, investigate performance issues, manage execution plans, and leverage built-in tuning capabilities in SQL Server and Azure SQL Database.

Key topics:

Query Store fundamentals

Query and plan history analysis

Performance regression detection

Query Store reports and insights

Plan forcing and plan management

Automatic tuning and best practices

Through live demos, you'll see how Query Store makes performance troubleshooting faster, simpler, and more reliable.

Speaker: Deepthi Goguri, SQL Database Administrator

Speaker Profile:

Deepthi is a SQL Server Database Administrator with several years of experience in Administering SQL Servers. She is a Microsoft Data Platform MVP, Microsoft certified trainer and Microsoft certified professional with an Associate and Expert level Certification in Data Management and Analytics. Deepthi blogs for DBANuggets.com.

Deepthi is a Co-Organizer for Microsoft Data and AI South Florida user group, Data TGIF, Cloud Data Driven User Group, Future Data Driven Summit, Databash Conference and Data Platform Diversity, Equity, and Inclusion Virtual Group. She is also DEI Steering Committee member for PASS Data Community Summit. She is a Redgate Community Ambassador. Along with this, Deepthi loves arts and crafts. You can contact her on Twitter @dbanuggets.