Improve Query Performance by Managing Statistics in Azure SQL | Data Exposed: MVP Edition

From the creator

Within Azure SQL maintenance tasks such as backups and integrity checks are handled for you, and while you may be able to get away with automatic updates keeping your statistics up-to-date, sometimes it's not enough. Proactively managing statistics in Azure SQL requires some extra steps, and in this Data Exposed episode with Erin Stellato, we'll step through how you can schedule and automate regular updates to statistics. 0:00 Introduction 1:15 Overview of statistics 2:00 Schedule & automate updates to statistics demo 7:02 Runbooks ✔️Resources: Github: https://github.com/olahallengren/sql-server-maintenance-solution?WT.mc_id=dataexposed-c9-niner SQL Server Index and Statistics Maintenance: https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html?WT.mc_id=dataexposed-c9-niner SQL Skills: https://www.sqlskills.com?WT.mc_id=dataexposed-c9-niner About Erin Stellato: Erin Stellato is a Data Platform MVP and lives outside Cleveland, OH. She has almost 20 years of technology experience and has worked with SQL Server since 2003. Her areas of interest include performance tuning, Query Store, Extended Events, and helping accidental/involuntary DBAs understand how SQL Server works. Erin is an active member of the SQL Server community, has volunteered for PASS at the local and national level, and is a regular speaker at conferences including the PASS Summit, SQLIntersection, and SQLBits. Outside of time with family and friends, she enjoys running, spinning, movies,

Published 2020-08-18 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.