Méthode PublisherMonitor.EnumPublications2

Article
02/01/2013

Returns additional information on publications at a monitored Publisher.

Espace de noms : Microsoft.SqlServer.Replication
Assembly : Microsoft.SqlServer.Rmo (en Microsoft.SqlServer.Rmo.dll)

Syntaxe

'Déclaration
Public Function EnumPublications2 As DataSet
'Utilisation
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

Valeur de retour

Type : System.Data.DataSet
A DataSet object that contains the following columns.

Column	Data type	Description
publisher_db	String	Is the name of the Publisher.
publication	String	Is the name of a publication.
publication_type	Int32	Is the type of publication, which can be one of the following values: 0 = Transactional publication 1 = Snapshot publication 2 = Merge publication
status	Int32	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	Int32	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	Int32	The highest latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication.
best_latency	Int32	The lowest latency, in seconds, for data changes propagated by the Log Reader or Distribution Agents for a transactional publication.
average_latency	Int32	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/time that the Distribution Agent ran.
retention	Int32	Is the retention period for the publication.
latencythreshold	Int32	Is the latency threshold set for the transactional publication.
expirationthreshold	Int32	Is the expiration threshold set for the publication if it is a merge publication.
agentnotrunningthreshold	Int32	Is the threshold set for the longest time for an agent not to have run.
subscriptioncount	Int32	Is the number of subscriptions to a publication.
runningdistagentcount	Int32	Is the number of Distribution Agents running for the publication
snapshot_agentname	String	Name of the Snapshot Agent job for the publication.
logreader_agentname	String	Name of the Log Reader Agent job for the transactional publication.
qreader_agentname	String	Name of the Queue Reader Agent job for an immediate updating transactional publication.
worst_runspeedPerf	Int32	Is the longest synchronization time for the merge publication.
best_runspeedPerf	Int32	Is the shortest synchronization time for the merge publication.
average_runspeedPerf	Int32	Is the average synchronization time for the merge publication.
retention_period_unit	Int32	Is the unit used to express retention.

Notes

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).