Subscriber Data Validation Failed

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.

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

One of the subscribers reports a failed data validation. Check the error logs to understand which subscriber has failed.

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