SQL Server 2022: Built-in Query Intelligence [Ep. 3] | Data Exposed

From the creator

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. 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 ✔️ Resources: Intelligent Query Processing: feature family additions: https://cloudblogs.microsoft.com/sqlserver/2022/09/15/intelligent-query-processing-feature-family-additions/ Query Store hints in SQL Server 2022: https://cloudblogs.microsoft.com/sqlserver/2022/09/08/query-store-hints-in-sql-server-2022/ Intelligent Query Processing: degree of parallelism feedback: https://cloudblogs.microsoft.com/sqlserver/2022/10/20/intelligent-query-processing-degree-of-parallelism-feedback/ Learn more about SQL Server 2022​: https://aka.ms/sqlserver2022 Download SQL Server 2022​: https://aka.ms/getsqlserver2022 Get our decks​: https://aka.ms/sqlserver2022decks What’s new for SQL Server 2022​: https://aka.ms/sqlserver2022docs Read the book​: https://aka.ms/sql2022book Try out the workshop​: https://aka.ms/sql2022workshop Try our demos​: https://aka.ms/sqlserver2022demos Watch Microsoft Mechanics​: https://aka.ms/sqlserver2022mechani

Published 2023-02-02 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.