Announcing Skill Me Up Live! Sign up today and save 60% on your first month using offer code LIVETRAINING at checkout.
Managing Performance with SQL Server 2016 Query Store
Lab
Intermediate
0 h 40 m
2019-04-05
Lab Overview
In this lab, you will configure and manage the query store in SQL Server 2016 to collect runtime statistics, queries, query plan history and other workload history within the database to assist with troubleshooting query performance issues, you will then identify and resolve poor performing queries in your database using SQL Server 2016 Query Store. You will also identify query plan regressions and how to address them with information gathered from the Query Store.
Exercises

In this exercise, you will configure and manage the query store in SQL Server 2016 to collect runtime statistics, queries, query plan history and other workload history within the database to assist with troubleshooting query performance issues.


In this exercise, you will identify and resolve poor performing queries in your database using SQL Server 2016 Query Store. You will also identify query plan regressions and how to address them with information gathered from the Query Store.

Real-Time Lab
Not Registered?
Create Account
Already Registered?
Login
What are Labs?

Labs are where you can get hands on experience from what you have learned from lectures. You get to work in real time in virtual machines at your pace.