sp_Blitz™ is a health check script created by Brent Ozar. It looks for configuration, security, health and performance problems, and reports back with a list of issues for you to look into. It’s great for quickly understanding the state of a server you’ve been asked to look after.
The list of issues is the script’s major draw. However, if you run the script regularly, it can also help you keep track of whether your server is getting better or worse. To help with tracking of changes, Brent added an option to make the sproc return a count of the issues found. This custom metric lets you monitor the health of your server by tracking that count.
To run this metric, you’ll need to download the script and install it on your SQL Server. Follow these instructions on Brent’s site.
You may want to adjust the @IgnorePrioritiesAbove parameter to exclude less important issues from the count. To do this, see the parameter documentation on Brent’s site.Issues found by sp_Blitz,