PublisherMonitor.EnumPublications2 Method
Returns additional information on publications at a monitored Publisher.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
Syntax
'Declaration
Public Function EnumPublications2 As DataSet
'Usage
Dim instance As PublisherMonitor
Dim returnValue As DataSet
returnValue = instance.EnumPublications2()
public DataSet EnumPublications2()
public:
DataSet^ EnumPublications2()
member EnumPublications2 : unit -> DataSet
public function EnumPublications2() : DataSet
Return Value
Type: System.Data.DataSet
A DataSet object that contains the following columns.
Column |
Data type |
Description |
|---|---|---|
publisher_db |
Is the name of the Publisher. |
|
publication |
Is the name of a publication. |
|
publication_type |
Is the type of publication, which can be one of the following values: 0 = Transactional publication 1 = Snapshot publication 2 = Merge publication |
|
status |
Maximum status of all Replication Agents associated with the publication, which can be one of the following values: 1 = Started 2 = Succeeded 3 = In progress 4 = Idle 5 = Retrying 6 = Failed |
|
warning |
Maximum threshold warning generated by a subscription belonging to the publication, which can be the logical OR result of one or more of the following values: 1 = Expiration. A subscription to a transactional publication has exceeded the retention period by more than the allowable threshold, as a percentage of the retention period. 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 exceeded the retention period by more than the allowable threshold, as a percentage of the retention period. 8 = Mergefastrunduration. The time taken to complete synchronization of a merge subscription exceeds the threshold over a fast network connection, in seconds. 16 = Mergeslowrunduration. The time taken to complete synchronization of a merge subscription exceeds the threshold over a slow or dial-up network connection, in seconds. 32 = Mergefastrunspeed. The delivery rate for rows during synchronization of a merge subscription has failed to maintain the threshold rate over a fast network connection, in rows per second. 64 = Mergeslowrunspeed. The delivery rate for rows during synchronization of a merge subscription has failed to maintain the threshold rate over a slow or dial-up network connection, in rows per second. |
|
worst_latency |
The highest latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication. |
|
best_latency |
The lowest latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication. |
|
average_latency |
The average latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication. |
|
last_distsync |
Is the last date/time that the Distribution Agent ran. |
|
retention |
Is the retention period for the publication. |
|
latencythreshold |
Is the latency threshold set for the transactional publication. |
|
expirationthreshold |
Is the expiration threshold set for the publication if it is a merge publication. |
|
agentnotrunningthreshold |
Is the threshold set for the longest time for an agent not to have run. |
|
subscriptioncount |
Is the number of subscriptions to a publication. |
|
runningdistagentcount |
Is the number of Distribution Agents running for the publication |
|
snapshot_agentname |
Name of the Snapshot Agent job for the publication. |
|
logreader_agentname |
Name of the Log Reader Agent job for the transactional publication. |
|
qreader_agentname |
Name of the Queue Reader Agent job for an immediate updating transactional publication. |
|
worst_runspeedPerf |
Is the longest synchronization time for the merge publication. |
|
best_runspeedPerf |
Is the shortest synchronization time for the merge publication. |
|
average_runspeedPerf |
Is the average synchronization time for the merge publication. |
|
retention_period_unit |
Is the unit used to express retention. |
Remarks
Commit any property changes to the PublisherMonitor object before calling this method because properties of this object may need to be loaded if they have not been loaded already.
The EnumPublications2 method can only be called by members of the db_owner or replmonitor fixed database roles on the distribution database.
Calling EnumPublications2 is equivalent to executing sp_replmonitorhelppublication (Transact-SQL).
See Also
Reference
Microsoft.SqlServer.Replication Namespace