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,
Issues found by sp_Blitz
This metric keeps track of the number of server issues found by sp_Blitz™. For the full list of issues, run “EXEC sp_Blitz”.
The T-SQL query that will collect data
Instances to collect from
Databases to collect from
Use collected or calculated values
Leave the Use a calculated rate of change between collections check box unchecked
An alert is not required