Overview
Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This session explains how SQL Server Query Store records query performance over time and demonstrates using it to investigate a sudden performance regression, including query duration, resource consumption, waits, and configuration.
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