First Responder Kit

My free First Responder Kit is packed with scripts, worksheets, and checklists like:

  • sp_Blitz, sp_BlitzIndex, sp_BlitzCache – free health check scripts
  • SQL Server Setup Checklist – with the common questions I get about configs
  • High Availability and Disaster Recovery Planning Worksheet – communicating your RPO and RTO clearly
  • The Data Professional Annual Salary Survey responses

It’s totally free because I’ve been there too. I know how hard it is to keep SQL Server fast and reliable, and I want to make your job easier. Later, if you need consulting or training for tough pains that have you stumped, I hope you’ll stop by.

  • This field is for validation purposes and should be left unchanged.


Also known as the fine manual that you probably won’t read at first. You’ll regret that later. It’s okay. I’m the same way.

Health Check: sp_Blitz

Is my SQL Server healthy, or sick?

Speed Check: sp_BlitzFirst

Why is my SQL Server slow right now?

Index Check: sp_BlitzIndex

Are my indexes designed for speed?

Query Check: sp_BlitzCache

Which queries have been using the most resources?

Who’s Doing What: sp_BlitzWho

Who’s running what queries right now?

Query Trending: sp_BlitzQueryStore

How has my query plan changed over time?

Recent First Responder Kit Changes

First Responder Kit Release: Now With 50% MORE Double Checking

So many things happen in mid-Summer. Dreams. Death. Pit stains. And FRK updates! Special thanks to @digitalohm for once again taking the axe to sp_DatabaseRestore. You are the only person on our email list who isn’t getting a Box O’ Tripe® You can download the updated here. sp_Blitz Improvements #872 @MosesOfJ pointed out that,…
Read More

First Responder Kit Release: Ça plane pour moi

Ah, May. Spring has sprung, and young people’s minds turn towards seasonal allergies. Special thanks to @digitalohm for the Differential Restore code and general sp_DatabaseRestore spiffiness. May you live to an age that can only be described in Unix. You can download the updated here. sp_Blitz Improvements #857 Do you have any idea how much…
Read More

sp_DatabaseRestore: Open Source Database Restore Stored Procedure

Welcome to the sp_DatabaseRestore documentation page. We were looking for a script that restores a database including the transaction log chain using the backup files in a folder. We also wanted it to be able to continue applying transaction log backups. In other words, we were looking for a custom Log Shipping solution. We could…
Read More
Pocket Square

First Responder Kit Updates: So Many Updates, Brent Quit

I got 128 GB of RAM just to develop sp_BlitzCache with! Also, thanks to @RichBenner @BrentOzar and @douglane for code, and @LitKnd and @HenrikStaunPoulsen for great ideas! Grab the newly updated First Responder Kit, and here’s what’s in it: sp_Blitz Improvements #677 Finally! A bug that isn’t ours! Microsoft forget to let SE clean up…
Read More