Issues found by sp_Blitz

This metric looks for configuration, security, health and performance problems, and reports back with a list of issues for you to look into.

Install metric...

Metrics install automatically if you have SQL Monitor installed.

If you are using Redgate’s SQL Server monitoring tool, SQL Monitor, you can instantly install and run this metric on your servers.

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, 5.0 out of 5 based on 4 ratings

Metric definition

Name

Issues found by sp_Blitz

Description

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

Select all

Databases to collect from

master

Collection frequency

86400

Use collected or calculated values

Leave the Use a calculated rate of change between collections check box unchecked

Metric collection

Enabled

Alert definition

An alert is not required