Number of active backups and restores

Install metric...

Metrics install automatically if you have Redgate Monitor installed.

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

This metric will display the total number of active backups and restores on a server. This can be used to correlate with other metrics to explain why disk IO and CPU usage could have changed.

Metric definition

Name

Number of active backups and restores

Description

Calculates the total number of "BACKUP DATABASE" and "RESTORE DATABASE" commands that are currently being run.

The T-SQL query that will collect data

Instances to collect from

All

Databases to collect from

All

Collection frequency

60

Use collected or calculated values

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

Metric collection

Enabled

Alert definition

This metric is most useful for comparing against others to find any correlation, and so an alert will not generally be useful.