Главная
Study mode:
on
1
Intro
2
Query Store - Custom capture policies
3
What are Query hints?
4
Applying Query hints Today
5
Introducing Query Store hints
6
Using Query Store hints
7
Database Compatibility Level Family
8
Intelligent Query Processing Feature Family
9
Parameter-sensitive plan problem
10
Common Parameter-sensitive plan workarounds
11
Parameter Sensitivity Plan (PSP) optimization
12
Boundary value selection (Example of Real Estate agents portfolio)
13
Feedback Workflow
14
Memory Grant Feedback (MGF)
15
With MGF Percentile Grant
16
Parallelism today
17
Cardinality Estimation today
18
What is CE Feedback?
19
CE Feedback implementation
20
CE Feedback Scenarios (High Level) Correlation
21
Leveraging CE Feedback
22
Query compilation today
23
Optimized Plan Forcing using Query Store
24
Approximate QP: Approximate Percentile
Description:
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only! Grab it Explore the built-in intelligence features of Azure SQL and SQL Server 2022 in this 50-minute SQLBits conference talk. Dive into the Intelligent query processing feature family, including improvements to memory grant feedback, degree of parallelism (DOP) feedback, and parameter sensitive plan optimization. Discover how these features enhance business-critical workloads without requiring application code changes. Examine the intelligent database feature family, database compatibility levels, and learn troubleshooting techniques using query store hints. Gain insights from speaker David Pless as he covers topics such as Query Store custom capture policies, applying Query hints, Parameter Sensitivity Plan optimization, Memory Grant Feedback, Cardinality Estimation feedback, and Optimized Plan Forcing using Query Store.

Built-in Intelligence with Azure SQL and SQL Server 2022 - Intelligent Query Processing and Database Features

SQLBits
Add to list
0:00 / 0:00