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.
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, v42 dated September 7, 2015, adds a few ignorable waits, fixes a few small bugs, and stops you from even trying to install on SQL 2000 compat mode. (I use CTEs, so 2000 isn’t supported.) I also warn you if you’re on SQL Server 2016 and you haven’t enabled the Query Store. Full change log.
Get started now:
- Download sp_Blitz®
- Read the sp_Blitz® documentation and the change log
- If you run into problems or questions, visit Support.BrentOzar.com
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.