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

How to Fix sp_BlitzIndex Aggressive Indexes Warnings

sp_BlitzIndex gives your indexes a psychiatrist-style evaluation. It’s a lot like a real psychiatrist: it’s just flagging behaviors, and there’s not necessarily anything wrong with being a hoarder, or a workaholic, or a furry. They’re just behavioral traits. Let your freak flag fly. One of the warnings is “Aggressive Indexes,” which means sys.dm_db_operational_stats reports minutes of…
Read More

First Responder Kit Release: Darn May Showers

There’s usually something that I think is funny in this space. Instead, I’m going to extend my already extensive day of civic duty by letting you know something interesting about jury duty.   Sometimes, if you show up when they ask you to, they can make you come back for a second day if they…
Read More
Pocket Square

First Responder Kit Release: Driving Miss Data

Ugh. Bungabase slow. When Grog try count meat, Glug eat meat. Then Grog get hungry and Glug try count meat. Bungalock. Need big head make bungabase fast. You big head? You can download the updated here. sp_Blitz Improvements #1459: A while back, Brent blogged about implicit transactions. In the comments, a smart commenter named Dan pointed…
Read More
Pocket Square

First Responder Kit Release: SQLBits was pretty awesome but now I have to do work again

APRIL FOOLS! IT’S ONLY MARCH FIRST! Tomorrow. Butthead. You can download the updated here. sp_Blitz Improvements #1407: @parlevjo2 gave us a check to make sure databases are owned by an existing user. Existence is everything, so I hear. #1416: After existence is probably location. After that is collation. @ktaranov let us know that our collation wasn’t all that. Especially…
Read More
Pocket Square

First Responder Kit Release: Sunday, Boring Sunday

This is a modified limited release. After a few new feature releases, we’re achieving stasis. You can download the updated here. There are a couple points from the last release that I really need to emphasize: sp_BlitzCache got some new columns added to the output for tempdb spills. If you want to keep logging it…
Read More

First Responder Kit Release: It’s Too Cold Not To Do A Release

You look just like a snake when you crawl like a worm. You can download the updated here. sp_Blitz Improvements #1310: @CferMN reported quite an odd conversion error! Turns out, division was a better idea than multiplication. #1341: We we missing the newest version of Windows, and we had a broken link. Thanks to @JaySpatzfor letting us know!…
Read More

Sizing A New Server? Start With Maintenance.

Clientele Most of out customers are on slightly (ahem) older (AHEM) hardware, and they have big questions: How do we know what kind of hardware we need? How do we load test it? How do we know what to change to make it better? The load test question is interesting, particularly because getting a reliable…
Read More