60 minute session
Introducing the SQL Server 2016 Query Store
In this session, attendees are introduced to the Query Store, a powerful feature introduced in SQL Server 2016 that provides insight into query performance at the database level. Using real-world examples, we show how Query Store automatically captures query history and how this information can be used to analyse and resolve performance problems more quickly.
In addition, attendees also learn how they can compare execution plans and even force them via the Query Store in situations where generating an alternative execution plan leads to performance problems.
Learning goals
- Understanding what the Query Store is exactly and which problems it solves
- Gaining insight into the architecture and workings of Query Store
- Learning how query performance data is stored and analysed
- Getting acquainted with built-in Query Store reports and Dynamic Management Views
- Understanding how and when to force execution plans via the Query Store
Level
Intermediate
Topics
Materials