Главная
Study mode:
on
1
Stream begins
2
Introductions
3
Query Store ON by default
4
Query Store hints
5
Intelligent Database Query Processing
6
Parameter-sensitive Plan (PSP)
7
Demo: PSP Optimization
8
Memory Grant Feedback - Persistence and Percentile
9
Cardinality Estimation (CE) Feedback
10
Demo: CE Feedback
11
Degree of Parallelism (DOP) Feedback
12
Query Compilation Replay
13
Approximate QP
14
Learn More
Description:
Explore the latest advancements in Azure SQL DB and SQL Server's Intelligent Query Processing in this comprehensive Data Exposed Live episode. Dive into groundbreaking query performance enhancements designed to improve critical parallel workloads at scale while adapting to evolving data landscapes. Learn about Query Store's default activation and hints, Parameter-sensitive Plan optimization, Memory Grant Feedback persistence and percentile, Cardinality Estimation Feedback, and Degree of Parallelism Feedback. Watch demonstrations of PSP Optimization and CE Feedback, and discover new features like Query Compilation Replay and Approximate QP. Gain valuable insights from experts Anna Hoffman and Pedro Lopes on Microsoft's mission to enhance database performance and efficiency.

Intelligent Database Futures in Azure SQL and SQL Server 2022 - Data Exposed Live

Microsoft
Add to list
0:00 / 0:00