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, v41 dated June 18, 2015, adds new ways to check for dangerously low memory, obscure wait type gotchas, and servers with so many cached plans that they’re approaching SQL Server’s limits. We’ve also improved a few checks, like warning when you’re backing up to the same drives where the databases live – now we tell you if it’s a one-off backup, or if you’ve developed a dangerous habit. Full change log.
Get started now:
- Download sp_Blitz®
- 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 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.