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. At right is a 5-minute video explaining how sp_Blitz® works.
Step 1: Download it as part of our First Responder Kit.
Step 2: Run the sp_Blitz.sql file. It’ll install sp_Blitz® in your master database by default, but you can put it in another database if you prefer and it’ll still work fine.
Step 3: In SSMS, run EXEC sp_Blitz. In 5-30 seconds, you’ll get a prioritized health check that tells you what’s broken or dangerous on your SQL Server. 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.
Step 4: Start fixin’ stuff. Every row has a URL where you can go for more details on how to fix a particular problem. Let the learning begin!
The current version, v51 dated May 18, 2016, adds new checks for dangerous modules and snapshot backups, compatibility with Amazon RDS, reprioritizes a lot of checks, and fixes a bunch of little bugs. We wanted to make it easier for you to use @IgnoreChecksAbove = 50 and get a flash briefing of what’s broken on the server. Full change log.
Overwhelmed by the results? We’re here to help with our quick, easy 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.