Azure SQL & SQL Server 2022: Intelligent Database Futures | Data Exposed Live

From the creator

Azure SQL DB and SQL Server introduced ground-breaking query performance enhancements under the Intelligent Query Processing family in the past few years. These make up the latest on Microsoft’s mission to make critical parallel workloads improve when running at scale while remaining adaptive to the constantly changing world of data! Learn more in this episode of Data Expose Live with Anna Hoffman and Pedro Lopes. 0:00 Stream begins 0:23 Introductions 3:06 Query Store ON by default 5:36 Query Store hints 16:41 Intelligent Database Query Processing 20:30 Parameter-sensitive Plan (PSP) 32:50 Demo: PSP Optimization 40:34 Memory Grant Feedback - Persistence and Percentile 45:45 Cardinality Estimation (CE) Feedback 50:56 Demo: CE Feedback 56:46 Degree of Parallelism (DOP) Feedback 59:42 Query Compilation Replay 1:00:48 Approximate QP 1:01:39 Learn More ✔️ Resources: Intelligent Query Processing: https://aka.ms/IQP Intelligent Query Processing Demos: https://aka.ms/IQPDemos Cardinality Estimation (SQL Server): https://aka.ms/sqlCE Learn more about SQL Server 2022​: https://aka.ms/sqlserver2022 Register to apply for the SQL Server 2022 Early Adoption Program and stay informed: https://aka.ms/EAPSignup Watch technical deep-dives on SQL Server 2022:​ https://aka.ms/sqlserver2022mechanics 📝 SQL Server 2022 Preview Playlist: http://aka.ms/dataexposed-sqlserver2022 📌 Let's connect: Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna Twitter: Pedro Lopes, https://twitter.com/SQL

Published 2021-12-15 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.