SQL Server Performance Office Hours Episode 90
In this video, I dive into some common challenges and questions related to SQL Server performance and tuning. I discuss when plan stability can actually be harmful, how to prioritize tuning efforts when management wants everything fixed, and offer tips on spotting concurrency problems before users complain. I also touch on why SQL Server might make seemingly "dumb" choices and how to reason about them. If you have any questions or topics you'd like me to cover, feel free to leave them in the comments. And as always, if you enjoy this content, consider subscribing, sharing, and supporting my channel. Plus, don't forget to check out the free SQL Server and Postgres database performance monitoring tool at code.erikdarling.com-it could be a game-changer for your database performance management. CHAPTERS 00:00:00 - Introduction 00:04:04 - When Plan Stability Hurts More Than It Helps 00:06:10 - Prioritizing Tuning When Management Wants Everything Fixed 00:09:52 - Spotting Concurrency Problems Before Users Complain 00:12:25 - Tuning Advice That Does More Harm Than Good 00:13:30 - Why SQL Server Makes Obviously Dumb Choices 00:15:42 - Wrap-Up ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🕵️♂️ 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