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

From the creator

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. 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 ✔️ Resources: Monitor performance by using the Query Store: https://learn.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-ver16 Learning Path (there’s a section on using Query Store) – Optimize query performance in Azure SQL: https://learn.microsoft.com/en-us/training/paths/optimize-query-performance-sql-server/ Query Store in SQL Server 2022: https://cloudblogs.microsoft.com/sqlserver/2022/08/18/query-store-is-enabled-by-default-in-sql-server-2022/ Query Store Hints in Azure SQL Database (previous Data Exposed episode): https://learn.microsoft.com/en-us/shows/data-exposed/query-store-hints-in-azure-sql-database Query Performance Insight for Azure SQL Database: https://learn.microsoft.com/en-us/azure/azure-sql/database/quer

Published 2023-07-27 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.