Looking into Parameter Sensitive Plan Optimization in SQL Server 2022 and how Foglight for SQL and Performance Investigator (PI) captures this performance of these queries.
So, is parameter sniffing a think of the past with SQL Server 2022? Well, it looks promising, but I wanted to understand how Foglight SQL PI would show me what’s going on. I took some sample code from...