SQL Server: Introduction to Query Store

By Erin Stellato
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.
Play course overview
Course info
Rating
(81)
Level
Beginner
Updated
Jan 31, 2017
Duration
3h 2m
Table of contents
Course Overview
Course Overview 2m
Introduction
Introduction and Traditional Troubleshooting Tools 2m Baseline Data 2m Traditional Tools vs. Query Store 5m Course Objectives and Structure 3m
Defining Query Store
Introduction and Query Store Basics 4m Demo: Query Store in Action - Part 1 6m Demo: Query Store in Action - Part 2 14m Viewing Query Store and Module Summary 1m
Implementing Query Store
Introduction 1m Demo: Enabling Query Store for a Database 8m Activating and Collecting Query Store Data 2m Demo: Query Store Activation and Collection 6m Storing Query Store Data 4m Demo: Query Store Data Storage 7m Flushing and Aggregating Query Store Data 3m Demo: Query Store Data Flushing and Aggregation 11m How Query Store Integrates with Query Processing 3m Runtime Statistics and Module Summary 2m
Forcing Plans with Query Store
Introduction and Options for Addressing Poor-performing Queries 2m Demo: Using a Plan Guide to Force a Plan 11m Plan Guide Details 2m Demo: Using Query Store to Force a Plan 10m Query Store Details and Plan Guides vs. Forcing Plan 3m Demo: How to Determine if a Forced Plan is Being Used - Part 1 12m Demo: How to Determine if a Forced Plan is Being Used - Part 2 6m Common Reasons for Failed Plan Forcing and Module Summary 3m
Practical Uses of Query Store
Introduction and Understanding Performance with Query Store 4m Demo: Understanding Performance with Query Store 14m Upgrade Testing 2m Demo: Using Query Store to Test an Application Change 17m Testing Specific to the Cardinality Estimator 2m Demo: Using Query Store to Test Cardinality Estimator Changes 6m Module Summary and Course Summary 3m
Description
Course info
Rating
(81)
Level
Beginner
Updated
Jan 31, 2017
Duration
3h 2m
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.

About the author
Erin Stellato
About the author

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.

More from the author
SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database
Intermediate
1h 27m
Jan 9, 2018
SQL Server: Analyzing Query Performance for Developers
Beginner
4h 2m
Sep 29, 2017
More courses by Erin Stellato

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT