What do you do when SQL Server is unusually slow?
Disaster strikes your SQL Server: queries are stalled, applications are down, customers are calling in like crazy, and your boss is in a panic. What do you do? What if the same thing happens, but you’re on vacation? (Can you hear your cell phone ringing now?) Is there someone on your team who can walk through a checklist to figure out what’s going on?
In this one-hour video, I show you how I do it:
Here are the scripts I use in the video:
- sp_WhoIsActive from Adam Machanic. For longer-term diagnostics, here’s how to run sp_whoisactive in a loop and store data to a table for later review.
- First Responder Kit scripts – sp_BlitzFirst, sp_BlitzCache, etc.
- Extended Events can help you catch failing queries that error out.
- The Dedicated Admin Connection (DAC) – a single scheduler available for emergency troubleshooting even when the server’s on fire.
Or, need hands-on help, fast? Don’t have time to learn the hard way? We’re here to help with our quick, easy SQL Critical Care® service that gets to the root cause of your database health and performance pains.