SQL Server Performance Office Hours Episode 85 Lisbon is for Lovers
In this video, I, Erik Darling from Darling Data, share insights from my recent family vacation in Lisbon, where we tackled five intriguing questions from my fans. We discussed topics ranging from optimized locking and SQL Server restarts to identifying throughput-killing queries and tuning vendor applications. While the background views of the replica Golden Gate Bridge and the train and airplane sounds might have given a taste of the city life, the discussion stayed focused on SQL Server performance and tuning strategies. Whether you're dealing with single primary key locks, optimizing parallelism, or working with third-party applications, there's always something to learn from these practical scenarios. Join me tomorrow as we explore more exciting questions and solutions from a quieter location! CHAPTERS 00:00:00 - Introduction 00:01:15 - Optimized Locking Discussion 00:03:38 - Server Restart Benefits 00:05:47 - Query Identification and Throughput 00:07:56 - Parallelism and Spills 00:09:23 - Vendor Application Tuning ━━━━━━━━━━━━━━━━━━━━━━━━━━ 🕵️♂️ 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