sp_Blitz

sp_Blitz Pro Tips for Managing Multiple Servers Centrally

Last Updated August 18, 2020

sp_Blitz is a free health check script that gives you a prioritized list of things to fix on your SQL Server. Here’s what the output looks like: Most of the time, you’ll want to work through the warnings in the order that they show up in the results, in priority order. How to Skip Checks…

[Video] Watch Brent Work on sp_Blitz

Last Updated April 5, 2020

Brent Ozar

sp_Blitz, Videos

During the quarantines, I’m looking for new ways to help you level up for free. I decided to start live-streaming whenever I’m working on things I can share with you publicly. I wanted to add a new check to sp_Blitz, so I figured I’d do it live on camera while you watch, and talk you…

How to Do a Free SQL Server Health Check

Last Updated November 18, 2017

Brent Ozar

First Responder Kit, Processes and Practices, sp_Blitz

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…

A Tourist’s Guide to the sp_Blitz Source Code, Part 1: The Big Picture

Last Updated November 16, 2017

Brent Ozar

First Responder Kit, sp_Blitz

sp_Blitz is our open source free SQL Server health check script. From a really high level, here’s what it does: Create #BlitzResult, a temp table to hold its output Check something on your SQL Server, and if it’s found, insert a row into #BlitzResult Check something else, and insert a row if it’s found Do that…

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

Last Updated September 22, 2020

Brent Ozar

First Responder Kit, sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex

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…

sp_Blitz v51: @IgnorePrioritiesAbove = 50 gets you a daily briefing

Last Updated November 16, 2017

Brent Ozar

sp_Blitz

You have a monitoring tool, but you’ve set up an email rule to dump all the alerts into a folder. You’re not particularly proud of that, but it is what it is. You’re just tired of the spam. Group query in the registered servers list But when you get in in the morning, you want…