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.
What you'll learn
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 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
- 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
- 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
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, spending 12 years of her career at two different software companies. Erin discovered a passion for all things data while completing her M.S. in Motor Control at the University of Michigan. As she entered the IT field, she discovered the power of relational databases. During her IT career, Erin has worked closely with customers, users and colleagues to support bus... more