sql performance Archives

Alerting on Bad Parameter Sniffing Using Automatic Tuning

October 31, 2022 by Tara Kizer

IMPORTANT NOTE: This requires SQL Server 2017 or newer, Query Store and Enterprise/Developer edition. In SQL Server 2016, we were given the Query Store feature, and all the perf tuners rejoiced. Finally we had a great tool to help us with parameter sniffing issues. These days, any time I work on a parameter sniffing issue … Read more

If You Like Your Query Plan, You Can Keep Your Query Plan

November 23, 2013November 18, 2013 by Mike Walsh

Period(*). I have two motives here. One – I liked the title and I’ve been having fun with titles lately (A couple weeks ago it was the true story of a SAN Failure with “Yes, Virginia, SANs Can Fail“). Two – it’s a good reminder and a couple recent conversations brought it up so I … Read more