Tara Kizer

Alerting on Bad Parameter Sniffing Using Automatic Tuning

by
sql server parameter sniffing

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

Tara’s favorite SQL Server 2012+ Feature

by

If you’re still on SQL Server 2008/2008 R2, you’re missing out on some great features. It’s no secret that Availability Groups are my favorite feature since SQL Server 2012. Back in the day, I was supporting complex environments with aggressive SLAs. On one particular system, I had Failover Clustering for HA, Asynchronous Database Mirroring for … Read more