Sign in to confirm you’re not a bot
This helps protect our community. Learn more

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

Microsoft Developer
588K subscribers
<__slot-el>
<__slot-el>
2.9K views 2 years ago #SQLServer #AzureSQL #SQLServer2022
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/sqls... Query Store hints in SQL Server 2022: https://cloudblogs.microsoft.com/sqls... Intelligent Query Processing: degree of parallelism feedback: https://cloudblogs.microsoft.com/sqls... Learn more about SQL Server 2022​: https://aka.ms/sqlserver2022 Download SQL Server 2022​: https://ak …...more
...more
SQL Server 2022: Built-in Query Intelligence [Ep. 3] | Data Exposed
77Likes
2,903Views
2023Feb 2
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/sqls... Query Store hints in SQL Server 2022: https://cloudblogs.microsoft.com/sqls... Intelligent Query Processing: degree of parallelism feedback: https://cloudblogs.microsoft.com/sqls... 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/sqlserver2022mechanics Read the SQL Server 2022 Blog Series​: https://aka.ms/sqlserver2022blogs Take the Microsoft Learning Path​: https://aka.ms/learnsqlserver2022 📽 More episodes in the SQL Server 2022 Series: https://aka.ms/sqlserver2022series 📌 Let's connect: Twitter: Anna Hoffman,   / analyticanna​​​   Twitter: Bob Ward,   / bobwardms   Twitter: AzureSQL, https://aka.ms/azuresqltw​​​ 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt Microsoft Developer: https://aka.ms/microsoftdeveloperyt #AzureSQL #SQLServer #SQLServer2022

Follow along using the transcript.

Microsoft Developer

588K subscribers