AI, Data Science & Cloud Certificates from Google, IBM & Meta
Become an AI & ML Engineer with Cal Poly EPaCE — IBM-Certified Training
Overview
AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
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