Query Store: How It Started…How It’s Going | Data Exposed
Vložit
- čas přidán 26. 07. 2024
- 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: learn.microsoft.com/en-us/sql...
Learning Path (there’s a section on using Query Store) - Optimize query performance in Azure SQL: learn.microsoft.com/en-us/tra...
Query Store in SQL Server 2022: cloudblogs.microsoft.com/sqls...
Query Store Hints in Azure SQL Database (previous Data Exposed episode): learn.microsoft.com/en-us/sho...
Query Performance Insight for Azure SQL Database: learn.microsoft.com/en-us/azu...
📌 Let's connect:
Twitter: Anna Hoffman, / analyticanna
Twitter: Kendal Van Dyke, / sqldba
Twitter: AzureSQL, aka.ms/azuresqltw
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: aka.ms/msazuresqlyt
Microsoft SQL Server: aka.ms/mssqlserveryt
Microsoft Developer: aka.ms/microsoftdeveloperyt
#AzureSQL #SQLServer - Věda a technologie
In my 33 year SQL Server career, every time I've heard vendor claims like "intelligent" or "self-tuning", it's led to more technically intensive and deeper work. Such technologies deal with lower hanging fruit, and add complexity to resolving problems they can't fix. So bring it on!