Skip to content

Latest commit

 

History

History

SQL Server User Group - Guatemala 2018

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.