SQLBits 2022

Options for Proactively Managing Statistics in SQL Server

I often recommend that folks proactively manage statistics, but I always seem to run out of time to talk about HOW to do that...this session will cover exactly that.

Have you ever wondered how you could manage statistics beyond having AUTO_UPDATE_STATISTICS for your databases enabled, using a maintenance plan, and/or using the default options in Ola Hallengren's script? If so, this session is for you. I'll talk through the method I use to figure out what statistics need frequent updates, which ones have skew, and which ones aren't as critical. This session will move quick, so have some coffee before and be ready to keep pace!

Feedback Link - https://sqlb.it/?6967

Speaker

Erin Stellato is a Principal Consultant with SQLskills and a Microsoft Data Platform MVP. She has worked with SQL Server since 2003. Her areas of interest include internals, performance tuning, and high and high availability and disaster recovery.

Erin Stellato's Sessions

Stabilizing Performance with Query Store

What You've Been Missing in SSMS

Parameter Sensitive Plan Optimization in SQL 2022 ... As Cool as it Sounds?

Query Store Best Practices

The SQL Leadership Panel

From Your Couch to the Cloud: When and Why to Choose the Azure Portal

Azure Data Studio and the Surprises Inside

Erin & Monica’s Favorite SQL Stuff

Options for Proactively Managing Statistics in SQL Server

Why You Need Query Store

Stop Tuning Queries and Start Tuning Your Workload

Why You Need Query Store

Plan Stability with Automatic Tuning in SQL Server and Azure

Extending your use of Extended Events

Kicking & Screaming: Replacing Profiler with Extended Events