Solving Real World Problems with SQL Server 2016 Query Store

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.
Course info
Rating
(37)
Level
Intermediate
Updated
Jul 20, 2017
Duration
2h 49s
Table of contents
Course Overview
Introduction
Solving Query Performance Regressions
Tracking Resource Consumption
Configuration and Architecture
Advanced Uses for Query Store
Conclusion
Description
Course info
Rating
(37)
Level
Intermediate
Updated
Jul 20, 2017
Duration
2h 49s
Description

Poor database performance is a widespread problem, and as data volumes increase it's only going to get worse. Up until now, identifying the poorly performing queries was challenging and difficult. SQL Server 2016 introduced the Query Store, which automatically tracks query performance. In this course, Solving Real World Problems with SQL Server 2016 Query Store, you'll learn how to solve difficult query performance problems in an easier, more efficient way. This course will show how to identify query performance regressions using the Query Store, how to identify queries using the most resources, and how to track the overall resource consumption at the database level. It'll also show some advanced uses of Query Store, such as upgrade tests and load tests. By the end this course, you’ll be able to use Query Store to identify and resolve what were previously very difficult performance problems.

About the author
About the author

Gail Shaw is a Data Platform MVP and holds the MCM certification for SQL Server. Her specialties are in performance tuning and database recovery for SQL Server. She is a frequent poster on the SQL Server Central forums, writes articles for both SQLServerCentral.com and Simple-Talk.com, and often speaks at SQLBits and the PASS Community Summit.

More from the author
More courses by Gail Shaw