Query Store, Live Query Statistics and Live Query Plans

/, SQL Server, SQL Server 2016/Query Store, Live Query Statistics and Live Query Plans
Sale!

Query Store, Live Query Statistics and Live Query Plans

$15.00 $4.00

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

Product Description

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

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.