Sign in to confirm you’re not a bot
This helps protect our community. Learn more

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

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
2.4K views 1 year ago #SQLServer #AzureSQL
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... Learning Path (there’s a section on using Query Store) – Optimize query performance in Azure SQL: https://learn.microsoft.com/en-us/tra... Query Store in SQL Server …...more
...more
Query Store: How It Started…How It’s Going | Data Exposed
58Likes
2,405Views
2023Jul 27
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... Learning Path (there’s a section on using Query Store) – Optimize query performance in Azure SQL: https://learn.microsoft.com/en-us/tra... Query Store in SQL Server 2022: https://cloudblogs.microsoft.com/sqls... Query Store Hints in Azure SQL Database (previous Data Exposed episode): https://learn.microsoft.com/en-us/sho... Query Performance Insight for Azure SQL Database: https://learn.microsoft.com/en-us/azu... 📌 Let's connect: Twitter: Anna Hoffman,   / analyticanna​​​   Twitter: Kendal Van Dyke,   / sqldba   Twitter: AzureSQL, https://aka.ms/azuresqltw​​​ 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQLServer

Follow along using the transcript.

Microsoft Developer

588K subscribers