You’ve downloaded sp_Blitz, sp_BlitzIndex, and sp_BlitzCache from the First Responder Kit, and you’ve run them a few times. You know there’s a ton of advice in there, but…it’s kinda overwhelming. Where should you even start? What should you tackle first? Are there parameters that would help diagnose your specific situation?
In this one-day course, I’ll walk you through running them on your production server, and we’ll interpret your results together. Space is limited in these particular live classes because I’ll be giving you advice on your specific server.
Here’s how the day will go:
- You’ll run sp_Blitz to do a server-wide health check
- You’ll run sp_BlitzFirst to look at your server’s wait stats and storage throughput since it started up
- You’ll graph the server’s performance over time with the Power BI Dashboard for DBAs
- You’ll run sp_BlitzCache to find the queries causing your top wait types, using my favorite parameters for deeper diagnosis and trending
- You’ll run sp_BlitzIndex to diagnose the most urgent indexing issues specifically related to your top wait types
- You’ll write up a report to hand off to the rest of your team about what you learned about your server today, and what actions everyone needs to take in order to see a performance boost
Throughout the day, as you have questions about the data you’re seeing, you can post screenshots in the class’s Slack channel and get advice from me (and the rest of the students!) You’ll learn not just from your own questions, but also from the data that the other students are sharing about challenges they’re facing, too.
This course is 100% demos: the only slides are the introductions at the start of the day, and the recap at the end of the day. The rest of the time, we’ll be working in SQL Server Management Studio. Roll up your sleeves and join me!
- You need sysadmin (SA) level access on one production SQL Server (not Azure SQL DB or Amazon RDS for this particular class.) This class simply doesn’t focus on development servers, full stop: this is about making performance better, and to see why it’s bad, you’ve gotta run diagnostic queries on the production instance.
- Install the First Responder Kit scripts (at minimum, use the Install Core Scripts file.)
- Install the Agent job to log performance data to tables every 15 minutes at least one day before the class (a week is even better)
What’s out of scope: I won’t be teaching you how to fix the problems on your server – that’s where our Fundamentals and Mastering classes come in. In this class, I’m focusing on how to use these scripts to write a good health and performance report. You won’t be handing me queries or tables to fix, but instead, I’m going to show you how to prove – with data, not feelings – where the problems are, and what you should focus on first.
This is an online class – I (Brent) host it in GoToWebinar, live with me on webcam, taking questions as we go through the material together. Audio can come through either your computer audio, or by dialing into a US phone number – headset recommended either way.
You can watch again later with Instant Replay – for one year after your live class, you can watch the Instant Replay recordings. Brush up on stuff you missed or revisit your favorite topics. It’s the best of both worlds: live training with me, plus reminders.
Class dates & times:
- February 28, 2020 online 9:00-5:00 Eastern (14:00-22:00 UTC) (click to see in your own time zone)
- April 10, 2020 online 9:00-5:00 Eastern (14:00-22:00 UTC) (click to see in your own time zone)
- June 18, 2020 online 9:00-5:00 Eastern (14:00-22:00 UTC) (click to see in your own time zone)