sp_replmonitorhelppublisher (Transact-SQL)
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.
Transact-SQL Syntax Conventions
| Column name | Data type | Description |
|---|---|---|
|
publisher |
sysname |
Is the name of a Publisher. |
|
distribution_db |
sysname |
Is 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 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. |
|
publicationcount |
int |
Is the number of publications belonging to the Publisher. |
