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. Here’s a 3-minute video explaining how sp_Blitz™ works:
How the sp_Blitz™ Windows app works – download and install it on your workstation, not the SQL Server itself. That way you can do health checks against any SQL Server in your shop. Run it, put in a server name, and it creates the sp_Blitz™ stored procedure temporarily that server’s TempDB. It creates a print-friendly report complete with links to web pages with more information. The Windows app also automatically updates itself with the latest version of sp_Blitz™, too.
How the sp_Blitz™ stored procedure works – if you’d rather review the code yourself (and hey, we wouldn’t blame you!), download it and read through the source code. You can install this stored procedure on any of your SQL Servers, and then run it repeatedly whenever you want an updated health check on that server.
Both the Windows app and the stored procedure do exactly the same checks by default, but the stored procedure lets you do more checks by playing around with the parameters. sp_Blitz™ usually takes 5-15 seconds to run. We work hard to make sure the queries don’t block any other end user queries, but just like any other script you get from the Internet, you should try it out in development first before you run it in production.
The current version dated December 1, 2013 adds bug fixes from Dick Baker, Christoph Müller-Spengler, Philip Dietrich, and Ricky Lively. Full change log.
Get started now:
- Download sp_Blitz™ or the sp_Blitz™ windows app
- Read the sp_Blitz™ documentation and the change log
- Red Gate SQL Monitor users can add the sp_Blitz™ custom metric
- Check your indexes with sp_BlitzIndex™
Overwhelmed by the results? We’re here to help with our quick, easy 3-4 day SQL Critical Care™ service that gets to the root cause of your database health and performance pains. Contact us for a free 30-minute sales consultation.