sp_replmonitorhelppublicationthresholds (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

sp_replmonitorhelppublicationthresholds (Transact-SQL)

 

Applies To: SQL Server

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.

Topic link icon Transact-SQL Syntax Conventions

  
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.

ValueDescription
0Transactional publication.
1Snapshot publication.
2Merge publication.
NULL (default)Replication tries to determine the publication type.
Column nameData typeDescription
metric_idintID 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.
titlesysnameName of the replication performance metric.
valueintThe threshold value of the performance metric.
shouldalertbitIs 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.
isenabledbitIs if monitoring is enabled for this replication performance metric for this publication; a value of 1 indicates that monitoring is enabled.

0 (success) or 1 (failure)

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.

Programmatically Monitor Replication

Community Additions

ADD
Show:
© 2016 Microsoft