I realised today that I haven’t written a post about Brent Ozar’s “First Responder Kit” a.k.a “Blitz”.
The kit is a pack of free stored procedures (and a few handy documents) to help you troubleshoot slow performing databases, and to improve the overall health of your database. Legend!
I’ve used the scripts a few times, and have found them very helpful at pointing out the issue, and even exposing issues you may not be aware of.
Check out the Brent’s posts here.
I definitely recommend you see some of Brent’s videos as well.