Skip to content

Latest commit

 

History

History
70 lines (50 loc) · 3.9 KB

sp-replmonitorhelppublisher-transact-sql.md

File metadata and controls

70 lines (50 loc) · 3.9 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sp_replmonitorhelppublisher (Transact-SQL)
sp_replmonitorhelppublisher returns current status information for one or more Publishers associated with a Distributor.
markingmyname
maghan
randolphwest
08/22/2024
sql
replication
reference
sp_replmonitorhelppublisher_TSQL
sp_replmonitorhelppublisher
sp_replmonitorhelppublisher
TSQL

sp_replmonitorhelppublisher (Transact-SQL)

[!INCLUDE SQL Server SQL MI]

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.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sp_replmonitorhelppublisher
    [ [ @publisher = ] N'publisher' ]
    [ , [ @refreshpolicy = ] refreshpolicy ]
[ ; ]

Arguments

[ @publisher = ] N'publisher'

The name of the Publisher the status of which is being monitored. @publisher is sysname, with a default of NULL. If NULL, information is returned for all Publishers that use the Distributor.

[ @refreshpolicy = ] refreshpolicy

[!INCLUDE ssinternalonly-md]

Result set

Column name Data type Description
publisher sysname The name of a Publisher.
distribution_db sysname The name of the distribution database used by a given Publisher.
status int Maximum 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
warning int Maximum 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 hasn't 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 hasn't 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 network connection.
32 = mergefastrunspeed - the delivery rate for rows during synchronization of a merge subscription 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 failed to maintain the threshold rate, in rows per second, over a slow network connection.
publicationcount int The number of publications belonging to the Publisher.

Return code values

0 (success) or 1 (failure).

Remarks

sp_replmonitorhelppublisher is used with all types of replication.

Permissions

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.

Related content