Session

Query Store hints in SQL Server 2022 and parameter sniffing Problem

Query Store hints leverage Query Store to provide a method to shape query plans without changing application code. Now are available in SQL Server 2022
You already know you have parameter sniffing issues, and now you need to figure out how to fix it. Learn how we resolve bad Parameter Sniffing with Query Store in SQL 2016/17/19 and how it can be resolved more efficiently and easy with Query Store hints in SQL 2022, to reduce the blast radius with index changes, query tuning, and database-level settings. I will discuss whether you should use Query Store hint or Parameter sensitive plan optimization, also new in SQL 2022 and it is also based on Query Store.
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