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


Number of active backups and restores


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


Databases to collect from


Collection frequency


Use collected or calculated values

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

Metric collection


Alert definition

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