All roles that want to learn what’s available to aid in SQL Server query troubleshooting space. That will be the developer that needs to squeeze every ounce of performance from his queries, to the DBA that has to understand the problem space of an ongoing performance issue.
Query Store in SQL Server 2016 is one of the most relevant improvements for production DBAs. It introduces the concept of click-once mitigation approach to query performance regression.
But that’s not the sum of all enhancements in the query performance analysis and troubleshooting space introduced in SQL Server recently.
In this session we will learn about other enhancements that can help you troubleshoot query performance.
Ranging from new xEvents to Showplan improvements, from LQS (and underlying infrastructure) to the revised Plan Comparison tool, learn how these can help you streamline the process of troubleshooting query performance and gain faster insights.
Why I Want to Present This Session:
The SQL Server engineering team has been adding so much to SQL Server, in terms of new capabilities and tools to streamline the query perf troubleshooting, that we want to showcase how it all comes together.
Latest posts by Pedro Lopes (see all)
- Gems to help you troubleshoot query performance - November 29, 2016
- Enhancements that will make your SQL database engine roar – 2016 SP1 Edition - November 29, 2016