Explore a groundbreaking approach to performance tuning in SQL Server 2016 with expert Robert Davis in this 55-minute conference talk from PASS Data Community Summit. Delve into the world of slow queries and learn how to leverage the Query Store feature for efficient plan comparison and analysis. Discover techniques for matching operations, capturing query data, and evaluating resource consumption. Through a comprehensive demonstration, gain insights into tracking queries with multiple plans, comparing execution strategies, and identifying top IO consumers. Master the art of analyzing average duration and execution time to optimize your database performance. Conclude with a summary of key takeaways and participate in a Q&A session to further enhance your understanding of this new paradigm in SQL Server performance tuning.
Overview
Syllabus
Intro
Slow Queries
Query Store
Plan Compare
Matching Operations
Querystore
Demo
Query Store Capture
Resource Consumption
Execution Time
Average Duration
Top 10 IO Consumption
Query with more than one plan
Track Queries
Compare Plans
Compare Query Plans
Summary
Questions
Taught by
PASS Data Community Summit
