Distributor Information, Publications

Article
03/01/2023

Applies to: SQL Server Azure SQL Managed Instance

The Publications tab provides summary information for all publications at the Distributor that is selected in the left pane.

The information that is displayed about the publications supported by the Distributor includes a column that contains the SQL Server 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.

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

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

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

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. 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 SQL Server 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 SQL Server 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.