Query Store is a new feature introduced in SQL Server 2016, which helps us in troubleshooting long running queries, queries with regressed plans, queries consuming most resources. Query Store typically works like a flight data recorder and retains the stored data even after the sudden shutdown of the server. In this lab, we will explore various capabilities of Query Store. In the first exercise, we will learn about Query Store options, and newly introduced catalog views to work with the Query Store. In the second exercise, we will learn to fix regressed queries by forcing a plan stored by the Query Store and will also look into few of the system stored procedures to work with Query Store. In the third exercise, we will learn to audit the SQL Server performance using Query Store and will look into new enhancements in SQL Server 2016 such as Live Query Statistics and Live Query Plans.
Exercise 1: Introduction to Query Store
Exercise 2: Query Store Plans
Exercise 3: Performance Auditing