Returns the threshold metrics set for a monitored publication. This stored procedure, which is used to monitor replication, is executed at the Distributor on the distribution database.
sp_replmonitorhelppublicationthresholds [ @publisher = ] 'publisher' , [ @publisher_db = ] 'publisher_db' , [ @publication = ] 'publication' [ , [ @publication_type = ] publication_type ] [ , [ @thresholdmetricname = ] 'thresholdmetricname'
- [ @publisher= ] 'publisher'
Is the name of the Publisher. publisher is sysname, with no default.
- [ @publisher_db= ] 'publisher_db'
Is the name of the published database. publisher_db is sysname, with no default.
- [ @publication= ] 'publication'
Is the name of the publication. publication is sysname, with no default.
[ @publication_type= ] publication_type
If the type of publication. publication_type is int, and can be one of these values.
Replication tries to determine the publication type.
Return Code Values
0 (success) or 1 (failure)
ID of the replication performance metric, which can be one of the following.
1expiration - monitors for imminent expiration of subscriptions to transactional publications.
2latency - monitors for the performance of subscriptions to transactional publications.
4mergeexpiration - monitors for imminent expiration of subscriptions to merge publications.
5mergeslowrunduration - monitors the duration of merge synchronizations over low-bandwidth (dial-up) connections.
6mergefastrunduration - monitors the duration of merge synchronizations over high-bandwidth (LAN) connections.
7mergefastrunspeed - monitors the synchronization rate of merge synchronizations over high-bandwidth (LAN) connections.
8mergeslowrunspeed - monitors the synchronization rate of merge synchronizations over low-bandwidth (dial-up) connections.
Name of the replication performance metric.
The threshold value of the performance metric.
Is if an alert should be generated when the metric exceeds the defined threshold for this publication; a value of 1 indicates that an alert should be raised.
Is if monitoring is enabled for this replication performance metric for this publication; a value of 1 indicates that monitoring is enabled.
sp_replmonitorhelppublicationthresholds is used with all types of replication.
Only members of the db_owner or replmonitor fixed database role on the distribution database can execute sp_replmonitorhelppublicationthresholds.