--- title: "SQL Server Replication 'Distributor Information' dialog box | Microsoft Docs" ms.custom: "" ms.date: "06/13/2017" ms.prod: "sql-server-2014" ms.reviewer: "" ms.technology: replication ms.topic: conceptual f1_keywords: - "sql12.rep.monitor.Distributor.Publications.f1" - "sql12.rep.monitor.Distributor.commonjobs..f1" - "sql12.rep.monitor.Distributor.SubscriptionSummary.merge.f1" - "sql12.rep.monitor.Distributor.SubscriptionSummary.snapshot.f1" - "sql12.rep.monitor.Distributor.SubscriptionSummary.tran.f1" ms.assetid: 1f499277-7f12-42ba-8cf4-52b683434944 author: MashaMSFT ms.author: mathoma manager: craigg --- # Distributor Information Dialog Box This topic provides information on the **Distributor** dialog box ## Publications The **Publications** tab provides summary information for all publications at the Distributor that is selected in the left pane. ### Options The information that is displayed about the publications supported by the Distributor includes a column that contains the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] instance of the Publisher. Otherwise, the publication information is the same as the publication information that is provided when you view publications in the Publisher view of Replication Monitor. For more information about the columns in the **Publications** tab, see [Publisher Information, Publications](publisher-information-publications.md). ## Subscription watch list ### Transactional replication Information for transactional subscriptions includes the name of the Publisher. Otherwise, the functionality and the information that is provided in this dialog box is the same as in the Publisher view. For more information about how to use this dialog box, see [Publisher Information, Subscription Watch List (Transactional Publication, SQL Server 2005 and Later)](publisher-information-subscription-watch-list-transactional.md). ### Merge replication Information for merge publication subscriptions includes the name of the Publisher. Otherwise, the functionality and the information that is provided in this dialog box is the same as in the Publisher view. For more information about how to use this dialog box, see [Publisher Information, Subscription Watch List (Merge Publication, SQL Server 2005 and Later)](publisher-information-subscription-watch-list-merge-publication.md). ### Snapshot replication Information for snapshot publication subscriptions includes the name of the Publisher. Otherwise, the functionality and the information that is provided in this dialog box is the same as in the Publisher view. For more information about how to use this dialog box, see [Publisher Information, Subscription Watch List (Snapshot Publication, SQL Server 2005 and Later)](publisher-information-subscription-watch-list-snapshot.md). ## Agents The **Agents** tab displays information about the agents and maintenance jobs that are associated with the Publisher and Subscriber. The agents that are available in the **Agents** tab for a Distributor in Distributor view include all the agents that are available in the **Agents** tab for a Publisher. However, the **Agents** tab for a Distributor in Distributor view also includes a Distributor Agent and a Merge Agent. For more information about the Snapshot, Log Reader, and Queue Reader agents, and maintenance jobs, see [Publisher Information, Agents](publisher-information-agents.md). Notice that when you are viewing agent information on the **Agents** tab for a Distributor, Publisher information is present for the Snapshot and Log Reader agents. However, in the **Agents** tab for a Distributor in Distributor view, you can also select **Distributor Agent** and **Merge Agent**. ### Options The following sections describe the data that is displayed on this tab for the Distributor Agent and Merge Agent. ### Distributor Agent **Status** The status of the agent. The following list shows the possible status values: - Error - Retry - Running - Not Running - Never started **Publisher** The [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] instance of the Publisher. **Publication** The name of the publication with which the agent is associated. **Subscription** The name of the subscription, in the form: [*SubscriberName*].[*Database*]. **Type** Type of replication: push, pull, or Anonymous. **Last Start Time** The last time at which the agent started. **Duration** The length of time that the agent has run. The time represents elapsed time if the agent is currently running, and total time if the agent has run previously. **Last Action** The last action that was performed during the most recent run of the agent. **Delivery Rate** The rate, in commands per second, at which initialization commands are committed in the distribution database during the most recent run of the agent. **Latency** The time, in seconds, that has elapsed between the most recent change being committed in the publication database, and the corresponding command being committed in the distribution database. **#Trans** The number of transactions committed in the distribution database during the most recent run of the agent. **#Cmds** The number of commands committed in the distribution database during the most recent run of the agent. A command is the same as a data change, such as an update. **Avg. #Cmds** The average number of commands per transaction during the most recent run of the agent. ### Merge Agent **Status** The status of the agent. The following list shows the possible status values: - Error - Retry - Running - Not Running - Never started **Publisher** The [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] instance of the Publisher. **Publication** The name of the publication with which the agent is associated. **Subscription** The name of the subscription, in the form: [*SubscriberName*].[*Database*]. **Type** Type of replication: push, pull, or Anonymous. **Last Start Time** The last time at which the agent started. **Duration** The length of time that the agent has run. The time represents elapsed time if the agent is currently running, and total time if the agent has run previously. **Last Action** The last action that was performed during the most recent run of the agent. **Delivery Rate** The rate, in commands per second, at which changes are committed in the distribution database. **Publisher Inserts** Number of INSERT commands applied at the Publisher. **Publisher Updates** Number of UPDATE commands applied at the Publisher. **Publisher Deletes** Number of DELETE commands applied at the Publisher. **Publisher Conflicts** The number of conflicts occurring at the Publisher during the merge process. **Subscriber Inserts** Number of INSERT commands applied at the Subscriber. **Subscriber Updates** Number of UPDATE commands applied at the Subscriber. **Subscriber Deletes** Number of DELETE commands applied at the Subscriber. **Subscriber Conflicts** The number of conflicts occurring at the Subscriber during the merge process. ## See Also [Start the Replication Monitor](monitor/start-the-replication-monitor.md) [Monitoring Replication](monitoring-replication.md)