SQL Server 2022: Built-in Query Intelligence [Ep. 3] | Data Exposed

preview_player
Показать описание
In this episode of Data Exposed with Anna Hoffman and Bob Ward, take advantage of performance and availability for faster queries and to help ensure business continuity. Accelerate query performance and tuning with no code changes required with new Intelligent Query Processing scenarios and Query Store enhancements.

00:00 Introduction
00:54 Query Store and Intelligent Query Processing
01:42 Intelligent Query Processing (IQP) NextGen
03:26 Parameter Sensitive Plan Optimization
04:40 Demo
10:55 The pain of MAXDOP
11:34 DOP feedback architecture
12:47 Summary

✔️ Resources:

📌 Let's connect:

🔔 Subscribe to our channels for even more SQL tips:

#AzureSQL #SQLServer #SQLServer2022
Рекомендации по теме
Комментарии
Автор

I'm a very firm believer in the sage advice that "One good test is worth a thousand expert opinions", which can also be comically but properly expressed by the movie title of "Show Me the Money"! The very short but pertinent and well executed demo in this 'tube was perfect for the point. Thank you very much for taking the time to put that together and thank you both and your support crew for what you're doing in this series.

jeffmoden
Автор

This is a great demo showing the new IGP features. Can’t wait to test it out and see the difference in our system once we upgrade to SQL Server 2022. Thank you!

mihirtanna
Автор

Thank you very much for the video, great. Is this option available in SQL Azure Management Instance? thanks. Willy

Guille