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!