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: aka.ms/IQP
Intelligent Query Processing Demos: aka.ms/IQPDemos
Cardinality Estimation (SQL Server): aka.ms/sqlCE
Learn more about SQL Server 2022​: aka.ms/sqlserv...
Register to apply for the SQL Server 2022 Early Adoption Program and stay informed: aka.ms/EAPSignup
Watch technical deep-dives on SQL Server 2022:​ aka.ms/sqlserv...
📝 SQL Server 2022 Preview Playlist: aka.ms/dataexpo...
📌 Let's connect:
Twitter: Anna Hoffman, / analyticanna
Twitter: Pedro Lopes, / sqlpedro
Twitter: AzureSQL, aka.ms/azuresqltw
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: aka.ms/msazure...
Microsoft SQL Server: aka.ms/mssqlse...
Microsoft Developer: aka.ms/microso...
#AzureSQL #SQLServer #SQLServer2022