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
  • White papers – on Availability Groups, Google Compute Engine, disaster recovery in the cloud, and more
  • Worksheets and e-books – like our SQL Server Setup Checklist and the HA/DR Worksheet

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.

Log in and you can download it instantly, or fill this out:

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

Instructions

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?

Query Check: sp_BlitzCache

Which queries have been using the most resources?

Index Check: sp_BlitzIndex

Are my indexes designed for speed?

Vital Stats: Power BI

Graph server and query performance over time.

Cloud Restores: sp_AllNightLog

How can I use the cloud for disaster recovery?

Query Trending: sp_BlitzQueryStore

How has my query plan changed over time?

Who’s Doing What: sp_BlitzWho

Who’s running what queries right now?

Recent First Responder Kit Changes

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 FirstResponderKit.zip 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
Menu
{"cart_token":"","hash":"","cart_data":""}