New Paradigm for Performance Tuning in SQL Server 2016
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.