YouTube
GitHub

First Responder Kit

  1. Home
  3. First Responder Kit
    5. Page 3

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.

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

Pocket Square

First Responder Kit Release: Treating Object References Like Object Instances, Man

Erik Darling
Object reference not set to an instance of an object. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1281 We’ve lowered the priority of Query Store being disabled. It’s just not as important as the backups you’re not taking and the corruption checks you’re not running. sp_BlitzCache Improvements #1253 Due to an unfortunate copy and paste incident,…
Read More

Announcing the Free First Responder Kit Power BI Dashboard

Brent Ozar
What the heck is going on inside your SQL Server? Why’s it so slow? I wrote sp_BlitzFirst to answer that question, but that only works right now. You have to be standing in front of your computer to do diagnostics when the problem strikes. So now, you can run sp_BlitzFirst, have it log data to a…
Read More

First Responder Kit Release: The Ides Of November

Erik Darling
IB Rewop This is a cleanup release to get some of the pull requests in that didn’t make it in before the precon. There’s also a secret unlockable character that Brent is blogging about next week! Please clap. You can download the updated FirstResponderKit.zip here. sp_Blitz Improvements #1199 We’ve updated the unsupported builds list! Now you can…
Read More

How to Get Live Query Plans with sp_BlitzWho

Brent Ozar
sp_BlitzWho is our open source replacement for sp_who and sp_who2. It has all kinds of really neat-o outputs like how many degrees of parallelism the query is using, how much memory it’s been granted, how long it’s been waiting for memory grants, and much more. If you’re on SQL Server 2016 SP1 or newer, it…
Read More
Pocket Square

First Responder Kit Release: Precon Precogs

Erik Darling
This release comes to you from a hotel room in Chicago: The land of fiscal insolvency and one shooting per hour. It’s pretty nice, otherwise. This release is to get the pre-precon important stuff in. As much as I’d like to push all the recent contributions through, between travel, speaking, and uh… what do the…
Read More

How to Log Wait Stats to Table with sp_BlitzFirst

Brent Ozar
When you’re analyzing SQL Server performance, one of the best places to start is wait stats. What’s your SQL Server waiting on? sp_BlitzFirst makes it really easy to trend this data over time for free with all currently supported versions of SQL Server (2008+). Just set up an Agent job to run this every 15 minutes:…
Read More

How to Do a Free SQL Server Performance Check

Brent Ozar
Your client or boss just said, “Find out why this SQL Server is slow.” You’ve already done a free SQL Server health check, and now you wanna investigate deeper. Step 1: Download & run sp_BlitzFirst. Start with wait stats, which tell you what the SQL Server has been waiting on since the service was last…
Read More

How to Do a Free SQL Server Health Check

Brent Ozar
Your boss or client came to you and said, “Give me a quick health check on this SQL Server.” Step 1: Download & run sp_Blitz. Go to our download page and get our First Responder Kit. There’s a bunch of scripts and white papers in there, but the one to start with is sp_Blitz.sql. Open…
Read More

Getting Help with a Slow Server

Tara Kizer
StackExchange users often ask, “Why is my server slow?” Here’s a few tips to get better, faster answers. Server information You may have already included server information in your question, but it may not be sufficient. Run sp_Blitz to output a lot of server information fast. Transact-SQL EXEC sp_Blitz @OutputType = ‘markdown’, @CheckServerInfo = 1 1…
Read More
Menu