SQL Server Performance Office Hours Episode 89
In this video, I dive into a lively session with the Darling Data community, answering five intriguing questions and sharing valuable insights. I cover topics ranging from the practicalities of using query store in SQL Server to the nuances of performance monitoring and the peculiarities of cloud environments. Whether you're curious about the best practices for maintaining indexes or want to know more about the challenges of performance in cloud databases, there's something for everyone. Additionally, I provide updates on my free, open-source performance monitoring tool, which continues to evolve and improve, and announce my upcoming speaking engagements at Pass Summit West, where I'll be discussing T-SQL and isolation levels. If you're looking to enhance your database skills or need expert guidance, don't forget to check out the links in the video description for training and consulting opportunities. CHAPTERS 00:00:00 - Introduction 00:01:30 - Office Hours Overview 00:03:45 - Monitoring Tool Update 00:05:15 - QueryStore and Performance Monitor 00:07:00 - Plan Cache Issues 00:08:25 - Query Store in Cloud Environments 00:10:00 - 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