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.
0_1_WWI_QueryStoreConfigurations_Default.sql
1_1_WWI_QueryStoreConfigurations.sql
1_2_WWI_QueryStoreLoop_1.sql
1_3_WWI_QueryStoreLoop_2_IX.sql
1_4_WWI_QueryStoreLoop_2.sql
1_5_WWI_QueryStoreLoop_3.sql
1_6_WWI_QueryStoreQuickLook.sql
1_7_AW_QueryStoreDuration_Plans.sql
2_1_WWI_QueryStoreConfigurations_Low.sql
2_2_WWI_QueryStoreDistinctText_1.sql
2_3_WWI_QueryStoreQuickLook.sql
2_4_WWI_QueryStoreDuration_Plans.sql
3_1_AW_QueryStoreConfigurations.sql
3_2_AW_QueryStoreLoop_1.sql
3_3_AW_QueryStoreParameterSensitivity.sql
3_4_AW_QueryStorePlanForcing.sql
3_5_AW_QueryStoreDuration_Plans.sql
Introduction to Query Store.pdf
README.md

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.