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

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…