SQL Server Performance Office Hours Episode 76 Paris Heatwave

In this video, I dive into some common SQL Server questions and share my insights from Paris, France-where the heat is intense and air conditioning remains a distant dream. I address whether hints can be the best long-term solution to query optimization issues, explaining that while they are not always necessary, they can provide critical guidance when needed. Additionally, I tackle why servers might feel slow even when CPU, memory, and IO appear fine, pointing out network latency and application processing as primary culprits. The video also covers what people often obsess over too much in execution plans-costs and percentages-and emphasizes the importance of focusing on actual performance data rather than estimated metrics. Lastly, I discuss common mistakes in fixing parameter sniffing issues and why deletes can take forever, even when only a few thousand rows are involved. With Paris' scorching temperatures as my backdrop, this session aims to provide practical advice for SQL Server administrators and enthusiasts alike. CHAPTERS 00:00:00 - Introduction 00:01:35 - Hints for Long-Term Solutions 00:04:02 - Performance Issues Beyond Hardware 00:05:30 - Execution Plan Analysis 00:06:28 - Delete Operations and Indexes ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🕵️‍♂️ 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