Episode

Query Store: How It Started…How It's Going | Data Exposed

with Anna Hoffman, Kendal Van Dyke

Data Exposed

Introduced in SQL Server 2016, Query Store is an essential tool for understanding and tuning query performance. We'll talk about what Query Store does for you, review the innovations in each new SQL server version, and explore how Query Store works together with Intelligent Query Processing in SQL Server 2022 and Azure SQL to improve and stabilize performance.

Chapters

  • 00:00 - Episode begins
  • 00:30 - Introductions
  • 01:20 - Query Store Basics
  • 03:00 - What can I do with Query Store?
  • 04:32 - What is the cost?
  • 04:59 - How is it implemented and in what versions?
  • 05:10 - Query Store History
  • 07:14 - Query Store and SQL Server 2022
  • 11:27 - Query Store and Intelligent Query Processing
  • 12:51 - How do I use it?
  • 15:30 - Closing

Connect

Azure
Azure SQL Database
SQL Server
SQL