Explore groundbreaking enhancements in Intelligent Query Processing for SQL Server 2019 and Azure SQL Database in this conference talk from PASS Data Community Summit. Delve into Microsoft's mission to improve critical parallel workloads at scale while adapting to the evolving data landscape. Learn about anxiety-free upgrades, memory grant feedback, query execution plans, and batch mode processing. Discover the benefits of adaptive thresholds, initial overhead considerations, compatibility levels, and adaptive joins. Gain insights into regression prevention, reporting thresholds, and the intelligent database world that began with SQL Server 2017 and advances significantly in SQL Server 2019 and Azure SQL Database.
SQL Server and Azure SQL Database Intelligent Query Performance
PASS Data Community Summit via YouTube
Overview
Syllabus
Introduction
Anxietyfree upgrades
Memory Grant Feedback
Query Execution Plan
Questions
Batch Mode
Batch Mode Demo
Regressions
BIWIN
MSSTDFs
MSSTDFs Demo
Adaptive Threshold
Initial Overhead
Compatibility Levels
Adaptive Joins
Does it have overhead
Adaptive Join
Adaptive Join with Hash Match
Reporting Threshold
Taught by
PASS Data Community Summit
Related Courses
-
The Real Self-Tuning Database
-
Azure SQL and SQL Server 2022 - Intelligent Database Futures
-
Intelligent Query Processing
-
SQL Server 2017 Database Engine Enhancements - Why You Should Upgrade to It
-
Built-in Intelligence with Azure SQL and SQL Server 2022 - Intelligent Query Processing and Database Features
-
Intelligent Database Futures in Azure SQL and SQL Server 2022 - Data Exposed Live
