3.3 How Automatic Tuning Mitigates Parameter Sniffing

Built atop 2016’s Query Store, 2017 adds Automatic Tuning: the ability to monitor Query Store, watch for query plans that have gotten worse over time, and automatically force the better prior plans. The problem is that it only works well if there’s one plan that actually works well for enough of the possible parameters. Demo Script…

Built atop 2016’s Query Store, 2017 adds Automatic Tuning: the ability to monitor Query Store, watch for query plans that have gotten worse over time, and automatically force the better prior plans. The problem is that it only works well if there’s one plan that actually works well for enough of the possible parameters. Demo Script...
Menu