PublicationMonitor.EnumSubscriptions2(SubscriptionResultOption) PublicationMonitor.EnumSubscriptions2(SubscriptionResultOption) PublicationMonitor.EnumSubscriptions2(SubscriptionResultOption) Method

정의

모니터링되는 게시를 구독하는 구독에 대한 추가 정보를 반환합니다. Returns additional information on subscriptions that are subscribed to the monitored publication.

public:
 System::Data::DataSet ^ EnumSubscriptions2(Microsoft::SqlServer::Replication::SubscriptionResultOption resultOption);
public System.Data.DataSet EnumSubscriptions2 (Microsoft.SqlServer.Replication.SubscriptionResultOption resultOption);
Public Function EnumSubscriptions2 (resultOption As SubscriptionResultOption) As DataSet
매개 변수
resultOption
SubscriptionResultOption SubscriptionResultOption SubscriptionResultOption

변환할 결과의 유형을 지정하는 SubscriptionResultOption 값입니다. A SubscriptionResultOption value that specifies the type of results to return.

반환

다음과 같은 열이 포함된 DataSet 개체입니다. A DataSet object that contains the following columns.

Column Data type Description
status Int32 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 Int32 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. 트랜잭션 게시에 대한 구독이 허용된 임계값(보존 기간에 대한 비율) 이상 보존 기간을 초과했습니다. 2 = Latency. 트랜잭션 게시자에서 구독자로 데이터를 복제하는 데 소요된 시간이 임계값(초)을 초과합니다. 4 = Mergeexpiration. 병합 게시에 대한 구독이 허용된 임계값(보존 기간에 대한 비율) 이상 보존 기간을 초과했습니다. 8 = Mergefastrunduration. 고속 네트워크 연결을 통해 병합 구독을 완전 동기화하는 데 소요된 시간이 임계값(초)을 초과합니다. 16 = Mergeslowrunduration. 저속 또는 전화 접속 네트워크 연결을 통해 병합 구독을 완전 동기화하는 데 소요된 시간이 임계값(초)을 초과합니다. 32 = Mergefastrunspeed. 고속 네트워크 연결을 통해 병합 구독을 동기화하는 동안 행의 배달 속도가 임계 속도(초당 행 수)를 유지하지 못했습니다. 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.
subscriber String Is the name of the Subscriber.
subscriber_db String Is the name of the database used for the subscription.
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 these values: 0 = Transactional publication 1 = Snapshot publication 2 = Merge publication
subtype Int32 Is the subscription type, which can be one of the following values: 0 = Push 1 = Pull 2 = Anonymous
latency Int32 The highest latency, in seconds, for data changes propagated by the Log Reader Agent or Distribution Agents for a transactional publication.
latencythreshold Int32 Is the maximum latency for the transactional publication above which a warning is raised.
agentnotrunning Int32 Is the length of time, in hours, during which the agent has not run.
agentnotrunningthreshold Int32 Is the length of time, in hours, that the agent has not run before a warning is raised.
timetoexpiration Int32 Is the length of time, in hours, before the subscription expires if not synchronized.
expirationthreshold Int32 Is the time, in hours, before the subscription expires that a warning is raised.
last_distsync DateTime Is the date/time that the Distribution Agent last ran.
distribution_agentname String Is the name of the Distribution Agent job for the subscription to a transactional publication.
mergeagentname String Is the name of the Merge Agent job for the subscription to a merge publication.
mergesubscriptionfriendlyname String Is the friendly name of the Merge Agent job for the subscription to a merge publication.
mergeagentlocation String Is the name of the server on which the Merge Agent runs.
mergeconnectiontype Int32 Connection used when synchronizing a subscription to a merge publication, which can be one of the following values: 1 = Local area network (LAN) 2 = Dial-up network connection
mergePerformance Int32 Performance of the last synchronization compared to all synchronizations for the subscription, which is based on the delivery rate of the last synchronization divided by the average of all previous delivery rates.
mergerunspeed Single Is the delivery rate of the last synchronization for the subscription.
mergerunduration Int32 Is the length of time to complete the last synchronization of the subscription.
monitorranking Int32 Is the ranking value used to order the subscriptions in the result set. For a transactional publication, it can be one of these values: 60 = Error 56 = Warning: performance critical 52 = Warning: expiring soon or expired 50 = Warning: subscription uninitialized 40 = Retrying failed command 30 = Not running (success) 20 = Running (starting, running, or idle) For a merge publication, it can be one of these values: 60 = Error 56 = Warning: performance critical 54 = Warning: long-running merge 52 = Warning: expiring soon or expired 50 = Warning: subscription uninitialized 40 = Retrying failed command 30 = Running (starting, running, or idle) 20 = Not running (success)
distributionagentjobid Byte [16] ID of the Distribution Agent job for subscriptions to a transactional publication.
mergeagentjobid Byte [16] ID of the Merge Agent job for subscriptions to a transactional publication.
distributionagentid Int32 ID of the Distribution Agent job for the subscription.
distributionagentprofileid Int32 ID of the agent profile used by the Distribution Agent.
mergeagentid Int32 ID of the Merge Agent job for the subscription.
mergeagentprofileid Int32 ID of the agent profile used by the Merge Agent.
Column Data type Description
status Int32 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 Int32 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 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.
subscriber String Is the name of the Subscriber.
subscriber_db String Is the name of the database used for the subscription.
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 these values: 0 = Transactional publication 1 = Snapshot publication 2 = Merge publication
subtype Int32 Is the subscription type, which can be one of the following values: 0 = Push 1 = Pull 2 = Anonymous
latency Int32 The highest latency, in seconds, for data changes propagated by the Log Reader Agent or Distribution Agents for a transactional publication.
latencythreshold Int32 Is the maximum latency for the transactional publication above which a warning is raised.
agentnotrunning Int32 Is the length of time, in hours, during which the agent has not run.
agentnotrunningthreshold Int32 Is the length of time, in hours, that the agent has not run before a warning is raised.
timetoexpiration Int32 Is the length of time, in hours, before the subscription expires if not synchronized.
expirationthreshold Int32 Is the time, in hours, before the subscription expires that a warning is raised.
last_distsync DateTime Is the date/time that the Distribution Agent last ran.
distribution_agentname String Is the name of the Distribution Agent job for the subscription to a transactional publication.
mergeagentname String Is the name of the Merge Agent job for the subscription to a merge publication.
mergesubscriptionfriendlyname String Is the friendly name of the Merge Agent job for the subscription to a merge publication.
mergeagentlocation String Is the name of the server on which the Merge Agent runs.
mergeconnectiontype Int32 Connection used when synchronizing a subscription to a merge publication, which can be one of the following values: 1 = Local area network (LAN) 2 = Dial-up network connection
mergePerformance Int32 Performance of the last synchronization compared to all synchronizations for the subscription, which is based on the delivery rate of the last synchronization divided by the average of all previous delivery rates.
mergerunspeed Single Is the delivery rate of the last synchronization for the subscription.
mergerunduration Int32 Is the length of time to complete the last synchronization of the subscription.
monitorranking Int32 Is the ranking value used to order the subscriptions in the result set. For a transactional publication, it can be one of these values: 60 = Error 56 = Warning: performance critical 52 = Warning: expiring soon or expired 50 = Warning: subscription uninitialized 40 = Retrying failed command 30 = Not running (success) 20 = Running (starting, running, or idle) For a merge publication, it can be one of these values: 60 = Error 56 = Warning: performance critical 54 = Warning: long-running merge 52 = Warning: expiring soon or expired 50 = Warning: subscription uninitialized 40 = Retrying failed command 30 = Running (starting, running, or idle) 20 = Not running (success)
distributionagentjobid Byte [16] ID of the Distribution Agent job for subscriptions to a transactional publication.
mergeagentjobid Byte [16] ID of the Merge Agent job for subscriptions to a transactional publication.
distributionagentid Int32 ID of the Distribution Agent job for the subscription.
distributionagentprofileid Int32 ID of the agent profile used by the Distribution Agent.
mergeagentid Int32 ID of the Merge Agent job for the subscription.
mergeagentprofileid Int32 ID of the agent profile used by the Merge Agent.

설명

ExcludeAnonymousSubscriptions 속성은 결과 집합을 필터링 하는 데 사용 됩니다.The ExcludeAnonymousSubscriptions property is used to filter the result set.

EnumSubscriptions2 메서드 db_owner 또는 replmonitor 배포 데이터베이스의 고정 데이터베이스 역할의 멤버만 호출할 수 있습니다.The EnumSubscriptions2 method can only be called by members of the db_owner or replmonitor fixed database roles on the distribution database.

호출 EnumSubscriptions2 를 실행 하는 것과 같습니다 sp_replmonitorhelpsubscription (Transact SQL)합니다.Calling EnumSubscriptions2 is equivalent to executing sp_replmonitorhelpsubscription (Transact-SQL).

적용 대상

추가 정보