The MSpublicationthresholds table is used to track replication performance metrics for a publication, with one row for each threshold value being monitored. This table is stored in the distribution database.
|Column name||Data type||Description|
|publication_id||int||Identifies the publication for which a threshold has been set.|
|metric_id||int||Identifies a replication performance metric being monitored as defined in the MSreplmonthresholdmetrics system table.|
|value||sql_variant||The threshold value of the metric being monitored.|
|shouldalert||bit||A value of 1 indicates that an alert should be generated when the metric exceeds the defined threshold.|
|isenabled||bit||A value of 1 indicates that monitoring is enabled for this replication performance metric.|