SQL Server Performance Office Hours Episode 93
In this video, I dive into five pressing questions from the SQL Server community, covering topics like performance monitoring tool alerts, SQL Server index usage, schema design pitfalls, plan cache bloat, and delete operations blocking everything. I share insights on how to handle parallelism issues, why SQL Server might ignore indexes, and the signs of poor schema design. Additionally, I discuss the factors that can lead to plan cache bloat and the challenges of managing it, especially in multi-database environments. I also touch on the potential issues that can arise from deletes, including the impact of foreign keys, cascading deletes, and triggers. Whether you're a seasoned SQL Server pro or just starting out, there's plenty to learn here. As always, I appreciate your support and encourage you to subscribe and share this content with your friends. CHAPTERS 00:00:00 - Introduction 00:02:58 - Filtering Parallelism Out of Blocking Alerts 00:04:45 - Why SQL Server Ignores Indexes That Look Perfect 00:08:21 - When Schema Design Is the Root Cause 00:10:29 - What Silently Causes Plan Cache Bloat 00:13:12 - Why Deletes Sometimes Block Everything 00:14:51 - 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