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.

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 Overview 1min
• Introduction 13mins
• Defining Query Store 25mins
• Implementing Query Store 45mins
• Forcing Plans with Query Store 48mins
• Practical Uses of Query Store 47mins