Hands-On-Lab: Query Store, Live Query Statistics and Live Query Plans

Hello Friends,

Here is another popular lab from Hands-On-Lab library: Query Store, Live Query Statistics and Live Query Plans.

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

SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.