Episode
SQL Server 2022: Built-in Query Intelligence (Ep. 3) | Data Exposed
with Anna Hoffman, Bob Ward
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.
Chapters
- 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
Recommended resources
- Intelligent Query Processing: feature family additions
- Query Store hints in SQL Server 2022
- Intelligent Query Processing: degree of parallelism feedback
- Learn more about SQL Server 2022
- Download SQL Server 2022
- Get our decks
- What's new for SQL Server 2022
- Read the book
- Try out the workshop
- Try our demos
- Watch Microsoft Mechanics
- Read the SQL Server 2022 Blog Series
- Take the Microsoft Learning Path
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.
Chapters
- 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
Recommended resources
- Intelligent Query Processing: feature family additions
- Query Store hints in SQL Server 2022
- Intelligent Query Processing: degree of parallelism feedback
- Learn more about SQL Server 2022
- Download SQL Server 2022
- Get our decks
- What's new for SQL Server 2022
- Read the book
- Try out the workshop
- Try our demos
- Watch Microsoft Mechanics
- Read the SQL Server 2022 Blog Series
- Take the Microsoft Learning Path
Have feedback? Submit an issue here.