SQL Server Performance Office Hours Episode 92
In this video, I dive into a variety of SQL Server topics, from improving your office hours experience to deep dives into blocking, query store, and parallel plans. I share insights on design choices that can lead to blocking hell, such as hardware limitations, isolation levels, and indexing strategies, and explain why force plans sometimes disappear or stop working in Query Store. Additionally, I explore how exchange operators contribute to latency and blocking in parallel plans, and discuss the nuances of throttling in Azure, which can masquerade as query slowness. Along the way, I also touch on my upcoming sessions at Pass Summit West and share some thoughts on custom alerting and monitoring tools. Whether you're a seasoned SQL Server professional or just starting out, there's plenty to learn and enjoy in this video. CHAPTERS 00:00:00 - Introduction 00:04:02 - Alerting on Custom SQL Server Alerts 00:08:35 - Design Choices That Lead to Blocking Hell 00:12:03 - Why Forced Plans Disappear From Query Store 00:13:01 - How Exchange Operators Add Latency and Blocking 00:16:15 - How Azure Throttling Masquerades as Query Slowness 00:17:36 - 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