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.

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?

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

[Video] Watch Brent Work on sp_Blitz

During the quarantines, I’m looking for new ways to help you level up for free. I decided to start live-streaming whenever I’m working on things I can share with you publicly. I wanted to add a new check to sp_Blitz, so I figured I’d do it live on camera while you watch, and talk you…
Read More

Updated First Responder Kit and Consultant Toolkit for March 2020

In the immortal words of “Orange” Julius Caesar as written by Shake’s peer, “Beware the bugs of March.” It took us 2,064 years, but we’ve finally fixed those bugs, plus added a couple of new features. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension:…
Read More

How to Track Performance of Queries That Use RECOMPILE Hints

Say we have a stored procedure that has two queries in it – the second query uses a recompile hint, and you might recognize it from my parameter sniffing session: Transact-SQL CREATE OR ALTER PROC dbo.usp_SearchUsers @Reputation INT AS BEGIN /* Query 1, always the same: */ SELECT COUNT(*) FROM dbo.Users; /* Query 2, recompiles…
Read More
How I Use the First Responder Kit

Updated First Responder Kit and Consultant Toolkit for February 2020

We spent Valentine’s Day removing the bugs from your chocolates. You’re welcome. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First Responder Kit: Import. Download the updated Consultant Toolkit in your account EU customers: check your email for the updated version from Gumroad,…
Read More
How I Use the First Responder Kit

Wanna Learn How I Use the First Responder Kit?

My newest class, How I Use the First Responder Kit, has been going great – but there’s a catch. I designed this class as a mix of training and consulting, so I’m giving you advice on your server as we go. Because of that, I can only fit so many people (around 50) per class.…
Read More
How I Use the First Responder Kit

Updated First Responder Kit and Consultant Toolkit for December 2019

It’s the hap-happiest season of all. To get the new version: Download the updated FirstResponderKit.zip Azure Data Studio users with the First Responder Kit extension: ctrl/command+shift+p, First Responder Kit: Import. Download the updated Consultant Toolkit in your account EU customers: check your email for the updated version from Gumroad, our European distributor Consultant Toolkit Changes…
Read More
How I Use the First Responder Kit

Announcing a New Live Online Class: How I Use the First Responder Kit

During the hands-on labs for my Mastering classes, when I’m answering an attendee question, this kind of thing happens a lot: Attendee: “How would I find the query causing that missing index recommendation?” Me: “Oh, good question – you can use the sp_BlitzCache @SlowlySearchPlansFor parameter. Here’s how it works.” (Does a quick demo) Attendees in…
Read More
Menu
{"cart_token":"","hash":"","cart_data":""}