sp_Blitz® – SQL Server Takeover Script

sp_Blitz® – Free SQL Server Health Check Script

You’ve got a Microsoft SQL Server that somebody else built, or that other people have made changes to over the years, and you’re not exactly sure what kind of shape it’s in. Are there dangerous configuration settings that are causing slow performance or unreliability?

You want a fast, easy, free health check that flags common issues in seconds, and for each warning, gives you a link to a web page with more in-depth advice.

That’s sp_Blitz in our First Responder Kit, and here’s how it works:

Download it in our free First Responder Kit.

Common sp_Blitz parameters

@CheckUserDatabaseObjects = 0 – turns off database checks like heaps and triggers. This makes sp_Blitz run way faster on systems with hundreds of databases.

@OutputServerName, @OutputDatabaseName, @OutputSchemaName, @OutputTableName – you can write sp_Blitz’s results to a central server for easier reporting, or just to a DBA utilities database on the same server.

@IgnorePrioritiesAbove = 50 – excludes lower-priority alarms like informational alerts. (You can use any priority level here.)

@Help = 1 – explains the rest of sp_Blitz’s parameters, plus the output columns as well.

How to skip checks or databases

Sometimes, you’re the honey badger, and you just don’t care. If you’d like to skip specific checks or databases, create a table like this:

Then, you can run sp_Blitz and point it at that table to get the list of servers, databases, or checks to skip:

Here’s the full list of check IDs to pick which ones to skip.

Getting support for sp_Blitz

sp_Blitz works on SQL Server 2008 and newer. If Microsoft supports it, so do we – unfortunately, that means SQL 2000 and 2005 are out of luck. We use a lot of cool DMVs and techniques that only work in current versions of SQL Server. For free interactive support, you’ve got a few good options:

Scared by the results? We can help.

Don’t have time to learn the hard way? We’re here to help with our quick, easy process that gets to the root cause of your database health and performance pains. Our 3-day SQL Critical Care gets to the root of your SQL Server pains and teaches you how to make your databases faster and more reliable. Learn more, see sample reports, and book a free call with me, Brent.

sp_Blitz Blog Posts

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

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…
Read More