First Responder Kit

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

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

First Responder Kit Updates: New Checks Across the Board

December 13, 2016

Brent Ozar

It’s the December to Remember Script Event, and we’ve got updates to everything. Shout out to our contributors this month: @BlitzErik, @RichBenner, @runamuk0, @SQLMonger, and @BrentOzar. Grab the newly updated First Responder Kit, and here’s what’s in it: sp_Blitz Improvements #591 – add check for 2016 Standard installed without Service Pack 1 (coded by @RichBenner) #615…

Updated First Responder Kit: sp_Blitz, sp_BlitzCache, sp_BlitzIndex

November 15, 2016

Brent Ozar

These improvements go great with cranberries. The food, not the b – actually, they go pretty well with the band, too. sp_Blitz Improvements #568 – @RichBenner added a check for the default parallelism settings sp_BlitzCache Improvements by @BlitzErik #495 – add warning for indexed views with missing stats #557 – bug fix – don’t alert…

Silent Demo: The Plan Cache

October 31, 2016

Brent Ozar

Shhh, and pay close attention. In 76 seconds, I’ll teach you something intriguing about the way SQL Server caches execution plans:

First Responder Kit Update: sp_BlitzCache Catches Cursors, Scalar Functions, and More

October 24, 2016

Brent Ozar

Every time we take on a client for our SQL Critical Care®, the very first thing we do is run the First Responder Kit scripts: sp_Blitz to get a health check, sp_BlitzFirst to check their wait stats, sp_BlitzIndex to look at their indexes, and sp_BlitzCache to see the most resource-intensive queries. Very often, these scripts surface…

Updated First Responder Kit: sp_Blitz markdown output, sp_BlitzIndex statistics checks

October 14, 2016

Brent Ozar

In addition to lots of bug fixes and tweaks, my favorite option is: sp_Blitz @OutputType = ‘markdown’ sp_Blitz @OutputType = ‘markdown’, @CheckServerInfo = 1, @CheckUserDatabaseObjects = 1 See, recently I’ve spent a lot of time looking at Stack questions going, “Man, if I just had the output of sp_Blitz, I bet I could answer that question…

What To Do If sp_BlitzFirst Warns About High Compilations

September 27, 2016

Erik Darling

dba, development, performance tuning, sql server

Compiles Aren’t The Same As Recompiles If you’re seeing high RECOMPILES, this post isn’t for you. We’ll talk about the differences between compiles and recompiles, but not how to troubleshoot recompiles. Recompiles mean one of two obvious things: You have a RECOMPILE hint at the stored procedure or statement level, or SQL found a reason…

Learn to Use sp_Blitz, sp_BlitzCache, sp_BlitzFirst, and sp_BlitzIndex with These Tutorial Videos

September 12, 2016

Brent Ozar

There have been so many improvements lately to our First Responder Kit scripts that it was time to update our tutorial videos. Each of these is about ten minutes long and shows how to use ’em: How to Use sp_Blitz for a Health Check How to Use sp_BlitzCache to Find Slow Queries How to Use…

First Responder Kit 2016-09: sp_Blitz, sp_BlitzCache, sp_BlitzIndex Improvements

September 3, 2016

Brent Ozar

First, thanks to 5 community volunteers for contributing code this month. In addition to lots of bug fixes, small stuff, and a new Github issue template (thanks, Konstantin Taranov) here’s the big improvements: sp_Blitz Changes @OutputServerName writes output to remote server (Haris Khan) – for years, these stored procs have had an @OutputServerName parameter just waiting to…

Query Tuning Week: How to Run sp_BlitzCache on a Single Query

August 19, 2016

Brent Ozar

The most popular way of using sp_BlitzCache® is to just run it – by default, it shows you the top 10 most CPU-intensive queries that have run on your server recently. Plus, it shows you warnings about each of the queries – if they’re missing indexes, experiencing parameter sniffing issues, running long, running frequently, doing…

Memory Grants Added to sp_BlitzCache and sp_BlitzFirst

August 8, 2016

Erik Darling

dba, development, performance tuning, sql server

Exciting New Doodads When SP3 for 2012 dropped, we were all super excited by the new query tuning-centric features that were at our disposal. Now all we had to do was get people to install SP3! Great features like this make patching an easier sell. Now with SP2 for 2014 out, a lot of those…