First Responder Kit

Home
First Responder Kit

Our free First Responder Kit (zip) 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 we’ve been there too. We’re database administrators and developers who know how hard it is to keep SQL Server fast and reliable, and we want to make your job easier. Later, if you need consulting for tough pains that have you stumped, we hope you’ll remember us and stop by.

Email*
Things I want*
- First Responder Kit (Scripts and Guides)
- Subscribe to email updates (3-4 per week)
- 6-Month DBA Training Plan
Marketing permissions*
I consent to receive email marketing from Brent Ozar Unlimited.
Our emails contain marketing stuff, so we need to give you some fine quality fine print: Brent Ozar Unlimited® will use the information you provide on this form to email you with updates and marketing. You can change your mind at any time by clicking the unsubscribe link in the footer of any email you receive from us, or by contacting us at Help@BrentOzar.com. We use Mailchimp as our marketing platform. By checking the box to subscribe, you acknowledge that your information will be transferred to Mailchimp for processing, and that we may process your information in accordance with these terms.
Comments
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. We’re 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 Year From Now These Will All Stop Working On 2008 And 2008R2

August 10, 2018

Erik Darling

You think I’m kidding. Time bomb. Boom. Get your upgrade underwear on. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1664 – We’re officially smart enough to not warn people that we’re recompiling our own stored procedures. #1669 – Reworded the stacked instances details. Servers may be installed and not running. #1687 – @josh-simar has servers linked with AD accounts,…

First Responder Kit Release: Like pssdiag, if pssdiag had parents who cared

June 27, 2018

Erik Darling

I went to the PFE and guess what he told me? Guess what he told me? He said girl you better try fix those spinlocks too No matter what you do, now run this tool You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1620: @AAvella schooled us on Group Policy registry settings. Someday, we’ll get our act…

How to Fix sp_BlitzIndex Aggressive Indexes Warnings

June 20, 2018

Brent Ozar

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…

First Responder Kit Release: Just When You Think There’s Nothing New Left To Do

June 4, 2018

Erik Darling

T*m* f*r An*th*r F*rst R*spond*r K*t R*l**s*. All joking aside! A big thank you goes out to a few people this go around: @jadarnel27 for not only contributing a bunch of Super Professional T-SQL, but also for writing a web scraping application to compile a list of current SQL Server versions. @nedotter @ktaranov and Aleksey Nagorskiy for putting together…

First Responder Kit Release: Darn May Showers

April 30, 2018

Erik Darling

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…

First Responder Kit Release: Driving Miss Data

March 29, 2018

Erik Darling

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 FirstResponderKit.zip here. sp_Blitz Improvements #1459: A while back, Brent blogged about implicit transactions. In the comments, a smart commenter named Dan pointed…

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

February 28, 2018

Erik Darling

APRIL FOOLS! IT’S ONLY MARCH FIRST! Tomorrow. Butthead. You can download the updated FirstResponderKit.zip 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…

First Responder Kit Release: Sunday, Boring Sunday

January 28, 2018

Erik Darling

This is a modified limited release. After a few new feature releases, we’re achieving stasis. You can download the updated FirstResponderKit.zip 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…

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

January 9, 2018

Erik Darling

You look just like a snake when you crawl like a worm. You can download the updated FirstResponderKit.zip 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!…

Sizing A New Server? Start With Maintenance.

December 22, 2017

Erik Darling

dba, sql server

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…