sp_replmonitorhelppublisher (Transact-SQL)

 

Applies To: SQL Server

Returns current status information for one or more Publishers associated with a Distributor. 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_replmonitorhelppublisher [ [ @publisher = ] 'publisher' ]  
    [ , [ @refreshpolicy = ] refreshpolicy ]  

[ @publisher = ] 'publisher'
Is the name of the Publisher the status of which is being monitored. publisher is sysname, with a default value of NULL. If NULL, information will be returned for all Publishers that use the Distributor.

[ @refreshpolicy= ] refreshpolicy
Internal use only.

Column nameData typeDescription
publishersysnameIs the name of a Publisher.
distribution_dbsysnameIs the name of the distribution database used by a given Publisher.
statusintMaximum status of all replication agents associated with publications at this Publisher, which can be one of these values.

 1 = Started

 2 = Succeeded

 3 = In progress

 4 = Idle

 5 = Retrying

 6 = Failed
warningintMaximum threshold warning generated by a subscription belonging to a publication at this Publisher, which can be the logical OR result of one or more of these values.

 1 = expiration – a subscription to a transactional publication has not been synchronized within the retention period threshold.

 2 = latency - the time taken to replicate data from a transactional Publisher to the Subscriber exceeds the threshold, in seconds.

 4 = mergeexpiration - a subscription to a merge publication has not been synchronized within the retention period threshold.

 8 = mergefastrunduration - the time taken to complete synchronization of a merge subscription exceeds the threshold, in seconds, over a fast network connection.

 16 = mergeslowrunduration - the time taken to complete synchronization of a merge subscription exceeds the threshold, in seconds, over a slow or dial-up network connection.

 32 = mergefastrunspeed – the delivery rate for rows during synchronization of a merge subscription has failed to maintain the threshold rate, in rows per second, over a fast network connection.

 64 = mergeslowrunspeed – the delivery rate for rows during synchronization of a merge subscription has failed to maintain the threshold rate, in rows per second, over a slow or dial-up network connection.
publicationcountintIs the number of publications belonging to the Publisher.

0 (success) or 1 (failure)

sp_replmonitorhelppublisher is used with all types of replication.

Only members of the sysadmin fixed server role at the Distributor or members of the db_owner or replmonitor fixed database roles in the distribution database can execute sp_replmonitorhelppublisher.

Programmatically Monitor Replication

Community Additions

ADD
Show: