SQL Server Performance Office Hours Episode 81 A Slightly Disordered Release Schedule
In this video, I dive into some common SQL Server questions that have been piling up during my vacation in Paris. From the technical intricacies of key lookups and their impact on server performance to the ongoing relevance of lock escalation issues, I provide insights based on real-world experiences and best practices. Additionally, I explore why Query Store might show different runtimes than what users actually experience and how to detect worker thread starvation-a critical aspect often overlooked but crucial for maintaining optimal database performance. Whether you're a seasoned SQL Server professional or just starting out, there's something here that will help you navigate these challenges more effectively. CHAPTERS 00:00:00 - Introduction 00:01:34 - SQL Server Performance and Key Lookups 00:03:27 - Lock Escalation Issues 00:05:32 - Query Store Runtime Discrepancies 00:06:49 - Latch Contention vs. Locking 00:08:13 - Worker Thread Starvation Detection ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🕵️♂️ 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