Skip to content
Branch: master
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
..
Failed to load latest commit information.
1_1_AW_QueryStoreTableStats.sql
1_2_AW_QueryStorePlanGuide.sql
3_1_WWI_QueryStoreConfigurations_Low.sql
3_2_WWI_QueryStoreLoop_1.sql
3_3_WWI_QueryStoreLoop_2.sql
3_4_WWI_QueryStoreLoop_2_IX.sql
3_5_WWI_QueryStoreLoop_4.sql
4_1_QueryStoreConfigurations.sql
4_2_QueryStoreQuickLook.sql
4_3_AW_QueryStoreLoop_1.sql
4_4_AW_QueryStoreDuration_Plans.sql
4_5_AW_QueryStorePlanForcing.sql
Introduction to Query Store.pdf
QueryStorePlanGuide.sql
README.md
SQLQueryStress.exe

README.md

Introduction to Query Store - September 2019

Abstract

Fixing SQL Server performance problems and detecting query regressions has been always challenging for DBAs, we have to deal with the fact that SQL Server does not capture query performance stats permanently on disk. Query Store is a new feature introduced in SQL Server 2016, which automatically captures a history of queries, plans, and runtime statistics, and retains these for later review.

Join me in this session, where we will be discussing more about Query store architecture, configuration and uses for real world scenarios.

You can’t perform that action at this time.