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.
Metric definition
Name
Description
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
Alert name
Description
Raise an alert when the metric value goes
the defined threshholds
Default threshold values
High: | |
Medium: | |
Low: |
Raise an alert when the threshold is passed for
collections