As a performance tuning consultant, I rely on Query Store to quickly identify and fix performance issues without needing in-depth knowledge of my clients’ code or applications. But what’s in it for you? Query Store provides powerful insights into query plan choices and performance, giving you more control over which execution plans the optimizer uses while helping you spot plan regressions.

And now, with SQL Databases in Fabric, Query Store continues to shine as it leverages this powerful feature to enhance performance insights and ensure consistent execution plans across your workloads.

In this session, we’ll explore how Query Store works, how to configure it for your environment (including Fabric), and most importantly, how it can save you time and effort by quickly highlighting performance differences caused by query plan changes, identifying anomalies, and solving issues in minutes. Through a combination of discussion and live demos, you’ll learn how Query Store answers the question, “Why was my query slow?” and why it should be your go-to tool for performance tuning in Azure SQL DB, Managed Instance, and now SQL Databases in Fabric.