The Perils of Secondary Metrics in SQL Server
In this video, I dive into the world of secondary metrics in SQL Server, which are often cited as key indicators of performance issues but are, in reality, not as valuable as primary metrics like wait stats and CPU/duration. I discuss why metrics like page life expectancy, disk queue length, and missing index requests, while commonly referenced, can be misleading and why focusing on actual performance bottlenecks is crucial. By highlighting these points, I aim to help you prioritize your efforts more effectively when tuning SQL Server performance, ensuring you address the real issues that impact query execution and user satisfaction. CHAPTERS 00:00:00 - Introduction 00:02:38 - Index Fragmentation 00:05:19 - Fill Factor Misconceptions 00:07:45 - Missing Index Requests 00:10:37 - Wait Stats and CXPACKET Waits 00:13:26 - Global Settings and Query Optimization 00:15:13 - Conclusion ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🕵️♂️ 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