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, v45 dated January 6, 2016, adds new memory-related checks, fixes lots and lots of bugs, and just generally tries to remove warnings that weren’t really actionable. 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.