60 minute session
Analyzing SQL Server Performance Through the Query Store
In this session we go deeper into analysing SQL Server performance using the Query Store. Where the basics of the Query Store are often familiar, the focus in this session is on actually leveraging the collected data to understand and resolve performance problems.
Attendees learn how query runtime statistics are built up and how these insights can be used in both standard reports and custom solutions. In addition, attention is paid to practical tooling, such as dashboards and scripts, with which performance analysis can be further automated.
Learning goals
- Better understanding how the Query Store functions in terms of statistics collection
- Gaining insight into runtime intervals and analysing query statistics over time
- Learning to work with built-in reports and Dynamic Management Views for performance analysis
- Understanding how to use Query Store data for troubleshooting and optimisation
- Getting acquainted with custom solutions such as dashboards and tooling (e.g. sp_WhatsupQueryStore)
- Gaining insight into automating and deepening performance monitoring using the Query Store
Level
Advanced
Topics
Materials