Session

Intelligent Query Processing in SQL Server 2022 next Gen the fast track!

Intelligent query processing—a family of features whose purpose is to improve the performance of existing workloads with no application changes or minimal implementation effort. Originally, SQL Server 2017, up to SQL Server 2022. In will cover:
• Overview of intelligent query processing
• Query Store hints in SQL Server 2022 and parameter sniffing Problem
• Parameter Sensitivity Plan optimization (PSP). Does it really work in all scenarios?
• Memory grant feedback: Percentile and persistence mode
• Adaptive joins and thresholds.
If time permits:
• Cardinality estimation feedback
• Degree of parallelism feedback
• Interleaved execution
• Table variable deferred compilation
This is a maximum demo session with minimum theory and real experience over more than 24 year!

Yitzhak David

DBA BDA POWER BI NOSQL K8s

Nahariyya, Israel

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.

Jump to top