SQL Server: Introduction to Query Store

One of the most highly anticipated new features in SQL Server 2016 is Query Store. It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely query plans and run-time statistics.
More
One of the most highly anticipated new features in SQL Server 2016 is Query Store. It's been referred to as the "flight recorder" for SQL Server because it tracks query information, namely query plans and run-time statistics.
More
Introduction
13m 18s
The Query Store feature is a game changer for how SQL Server professionals troubleshoot query performance. This is the first time Microsoft has provided the ability to natively capture baseline data within SQL Server. In this course, SQL Server: Introduction to Query Store, you'll configure Query Store and understand how the settings affect the data stored. First, you'll review the different options for Query Store and will look at examples of what gets collected. Next, you'll dig through the included reports. Finally, you'll see how you can force SQL Server to use a specific plan for a query. By the end of this course, you'll be more confident with Query Store, as it will show you how to enable and configure Query Store.
Table of Contents
Introduction
13m 18s
Description
The Query Store feature is a game changer for how SQL Server professionals troubleshoot query performance. This is the first time Microsoft has provided the ability to natively capture baseline data within SQL Server. In this course, SQL Server: Introduction to Query Store, you'll configure Query Store and understand how the settings affect the data stored. First, you'll review the different options for Query Store and will look at examples of what gets collected. Next, you'll dig through the included reports. Finally, you'll see how you can force SQL Server to use a specific plan for a query. By the end of this course, you'll be more confident with Query Store, as it will show you how to enable and configure Query Store.
Course info
Level
Beginner
Rating
Duration
3h 2m
Updated
31 Jan 2017
Course authors

Erin Stellato is a Principal Consultant with SQLskills and a SQL Server MVP. She has worked as a SQL Server professional since 2003 and her interests include Internals, Performance Tuning, High Availability and Disaster Recovery. Erin is an active member of the SQL Server community as a presenter and blogger.

Share course