Lead AI-Native Products with Microsoft's Agentic AI Program
Power BI Fundamentals - Create visualizations and dashboards from scratch
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
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.
Syllabus
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
Taught by
PASS Data Community Summit