As a Performance Tuning consultant, I live and breathe Query Store every day. It allows me to quickly find and fix performance issues without needing to understand my clients' code or applications fully. The Query Store feature provides invaluable insight into query plan choices and performance, offering more control over execution plans and helping identify plan regressions. In this session, we'll explore what Query Store is, how it works, and how to configure it for your environment. You'll also learn how to leverage the underlying DMVs to gather even more information. Through a combination of discussion and demos, we’ll cover how to quickly spot performance differences caused by query plan changes, identify performance anomalies, and resolve issues in minutes. You'll leave this session equipped to answer the crucial question, "Why was my query slow?"
Topics that will be discussed include:
- Understanding and configuring Query Store for optimal performance
- Using Query Store to identify and resolve query plan regressions
- Leveraging DMVs for deeper insights into query performance
- Techniques for quickly identifying and fixing performance anomalies
- Practical demos on resolving SQL Server performance issues
Speaker:
- Monica Rathbun, Microsoft MVP for Data Platform, Microsoft Certified Solutions Expert, and VMware vExpert