Export (0) Print
Expand All

PublisherMonitor.EnumDatabasePublications Method

Returns information about publications that use a specified publication database.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

public DataSet EnumDatabasePublications(
	string publicationDatabase
)

Parameters

publicationDatabase
Type: String
The name of the publication database.

Return Value

Type: DataSet
A DataSet object that has the following columns.

Column name

Data type

Description

publisher_db

sysname

Is the name of the Publisher.

publication

sysname

Is the name of a publication.

publication_type

int

Is the type of publication, which can be one of these values.

0 = Transactional publication

1 = Snapshot publication

2 = Merge publication

status

int

Maximum status of all replication agents associated with the publication, 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 the publication, 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.

worst_latency

int

The highest latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication.

best_latency

int

The lowest latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication.

average_latency

int

The average latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication.

last_distsync

datetime

Is the last date and time that the Distribution Agent ran.

retention

int

Is the retention period for the publication.

latencythreshold

int

Is the latency threshold set for the transactional publication.

expirationthreshold

int

Is the expiration threshold set for the publication if it is a merge publication.

agentnotrunningthreshold

int

Is the threshold set for the longest time for an agent not to have run.

subscriptioncount

int

Is the number of subscriptions to a publication.

runningdistagentcount

int

Is the number of distribution agents running for the publication.

snapshot_agentname

sysname

Name of the Snapshot Agent job for the publication.

logreader_agentname

sysname

Name of the Log Reader Agent job for the transactional publication.

qreader_agentname

sysname

Name of the Queue Reader Agent job for a transactional publication that supports queued updating.

worst_runspeedPerf

int

Is the longest synchronization time for the merge publication.

best_runspeedPerf

int

Is the shortest synchronization time for the merge publication.

average_runspeedPerf

int

Is the average synchronization time for the merge publication.

retention_period_unit

int

Is the unit used to express retention.

The EnumDatabasePublications method can only be called by members of the db_owner or replmonitor fixed database roles on the distribution database.

Calling EnumDatabasePublications is equivalent to executing sp_replmonitorhelppublication.

Community Additions

ADD
Show:
© 2015 Microsoft