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.
Email
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

New sp_Blitz® v35 Checks for Unsupported and Dangerous SQL Server Builds

July 3, 2014

Brent Ozar

News broke recently of a dangerous data loss bug in SQL Server 2012 and 2014, and Aaron Bertrand explained which patch levels are affected. It’s kinda tricky, and I’m afraid most people aren’t even going to know about the bug – let alone whether or not they’re on a bad version. I added build number checking into…

Introducing sp_BlitzCache®

May 6, 2014

Jeremiah Peschka

Finding the worst queries in SQL Server is easy, right? You just query one of the dm_exec_* DMVs, bring in the SQL text and the execution plan, and then you spend hours looking at execution plans trying to figure out what’s wrong in the query, much less how to fix it. All that’s changing – we’re introducing sp_BlitzCache®.…

Celebrating Two Years of sp_Blitz® (And a New Version)

October 12, 2013

Brent Ozar

Two years ago this week, I took to the stage at the PASS Summit 2011 and unveiled sp_Blitz®, my free health check stored procedure that helps you rapidly take over SQL Servers you’ve never seen before. Some historical highlights include: 117,125 downloads 117 checks (technically much more than that, because we look for variations of…

How to Find ‘Secret Columns’ in Nonclustered Indexes

July 25, 2013

Kendra Little

sp_BlitzIndex® just can’t keep a secret. That’s a feature, not a bug. I wrote sp_BlitzIndex® specifically so that it would rat out some things that SQL Server is doing behind the scenes to secretly help you out– because it’s really better if you know about it. What are secret columns? SQL Server needs a unique…

sp_BlitzIndex® Holiday Week Edition

December 24, 2012

Kendra Little

sp_blitzindex

Only one thing could have dragged me away from the soft glow of the electric leg lamp glowing in the window… sp_BlitzIndex® It’s one of those weeks when things get nice and slow. Your business users and managers are all out of the office due to holidays. Your inbox is blissfully quiet. You get a…

Instant Index Insight: How to Use sp_BlitzIndex® (video)

December 14, 2012

Kendra Little

sp_blitzindex

You probably don’t have enough time to dig through DMVs trying to figure out which indexes you should add or drop. Whether you’re a DBA or developer, junior or senior, you’re probably too busy doing your real job to master all the index best practices – and now you don’t have to. In this 30…