SQL Server Performance Office Hours Episode 84 - Adios Azores
In this video, I discuss a variety of SQL Server topics while navigating the challenges of filming from a moving boat. Despite the gimbal's attempts to distract me, we managed to get a nice view over the Azores. Today, we tackle questions ranging from parameter sniffing and its root causes to tuning deletes that randomly take forever and block everything else. I also address random latency spikes and the dangers of disabling auto update statistics in production. As we wrap up our time here, I share my usual advice on query and index tuning, and I remind viewers that we'll be back with another office hours video on Tuesday. Stay tuned! CHAPTERS 00:00:00 - Introduction 00:01:30 - Parameter Sniffing Basics 00:04:52 - Resource Semaphore Waits 00:06:25 - Tuning Deletes 00:07:30 - Random Latency Spikes ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🕵️♂️ FREE SQL SERVER MONITORING & Plan Analysis ━━━━━━━━━━━━━━━━━━━━━━━━━━ https://github.com/erikdarlingdata/PerformanceMonitor https://github.com/erikdarlingdata/PerformanceStudio https://plans.erikdarling.com/ ━━━━━━━━━━━━━━━━━━━━━━━━━━ 📚 TRAINING & COURSES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Get AI-Ready With Erik https://training.erikdarling.com/get-ai-ready-with-erik?coupon=AIREADY SQL Server Performance Engineering Course https://training.erikdarling.com/sql-server-performance-engineering?coupon=ENGINEERING Learn T-SQL with Erik https://training.erikdarling.com/learn-t-sql-with-erik?coupon=ADVANCEDTSQL Everything Bundle: https://training.erikdarling.com/?coupon=SPRINGCLEANING ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🛠️ CONSULTING & SERVICES ━━━━━━━━━━━━━━━━━━━━━━━━━━ Need SQL Server performance help? https://training.erikdarling.com/sqlconsulting ━━━━━━━━━━━━━━━━━━━━━━━━━━ 💬 CONNECT ━━━━━━━━━━━━━━━━━━━━━━━━━━ Ask questions at Office Hours https://erikdarling.com/officehours/ Become a channel member https://www.youtube.com/@ErikDarlingData/join