Query Store

Apply the new Query Store feature to identify and fix poorly performing queries in SQL Server.
Query Store is an important and recent feature in SQL Server that provides insight into the details of query execution and how that execution has changed over time. Query Store helps to identify queries that aren’t performing well, or that have regressed in their performance. Query Store provides detailed information such as wait stats that you need to resolve root causes, and it allows you to force the use of a known good execution plan. With SQL Server 2017 and later you can automate the correction of regressions in performance.

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.

Poor database performance is a widespread problem. This course will show you how SQL Server 2016's Query Store makes solving many query performance problems much easier than before.

Identify and fix causes of poor performance. You will learn Query Store, adaptive execution plans, and automated tuning on the Microsoft Azure SQL Database platform. Anyone responsible for writing or creating T-SQL queries will find valuable the insight into bottlenecks, including how to recognize them and eliminate them.