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.
Uses the data from sysreplication alerts within the msdb database to identify any alerts of value 20574. This indicates a data validation of the subscriber. You will have to look to the error log to understand exactly which subscriber has failed. Only run this on a distribution server.
Metric definition
Name
Subscriber Data Validation Failed
Description
Uses the data from sysreplication alerts within the msdb database to identify any alerts of value 20574. This indicates a data validation of the subscriber. You will have to look to the error log to understand exactly which subscriber has failed. Only run this on a distribution server.
The T-SQL query that will collect data
Instances to collect from
Only those with distributors
Databases to collect from
msdb
Collection frequency
1 minute
Use collected or calculated values
Leave the Use a calculated rate of change between collections check box unchecked
Metric collection
ENABLED
Alert definition
Alert name
Subscriber Data Validation Failed
Description
Raise an alert when the metric value goes
the defined threshholds
Default threshold values
High: | 0 |
Medium: | |
Low: |
Raise an alert when the threshold is passed for
1 time collections
Alert is
DISABLED