Go, Go, QueryStore! - Upgraded

Explore the powerful QueryStore feature in SQL Server 2016 and its enhancements in SQL Server 2017 through this informative conference talk. Discover how to identify and resolve performance regressions with ease using QueryStore. Learn about its functionality, configuration, and practical applications through demonstrations of longest running queries, highest duration queries, and resource-consumed queries. Gain insights into analyzing query performance, understanding wait statistics, and leveraging QueryStore to troubleshoot sudden performance degradations without the need for prior benchmarking or time machines.

Introduction
Overview
Longest Running Queries
What is QueryStore
Longest Running Query
Highest Duration Query
Average Duration Query
Resource Consumed Query
What Waits
QueryStore Configuration
QueryStore Demo