Export (0) Print
Expand All
Expand Minimize

Replication Monitor - Select Columns, Transactional Publication View Tab

SQL Server 2000

The following options are available on the Trans Publication View tab of the Replication Monitor - Select Columns dialog box.

Option Description
(check box) Display the selected column in the result pane.
Type Type of subscription.
Status Status of the agent's last action.
Last action Last action taken.
Action time Time the action was taken.
Start time Time this session was started.
Duration Duration of the agent session.
Delivery rate (cmds/sec) Ratio of delivered commands to the duration of the agent. If the agent is still running, this value reflects a cumulative count from the beginning of the session.
Latency (msec) For the Snapshot or Log Reader Agent, this is the current amount of time, in milliseconds, elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor.

For the subscription, this is the current amount of time, in milliseconds, elapsed from when transactions are delivered to the Distributor to when they are applied at the Subscriber.

#Trans For the Snapshot or Log Reader Agent, this is the number of transactions delivered to the Distributor.

For the subscription, this is the number of transactions delivered to the Subscriber.

#Cmds For the Snapshot or Log Reader Agent, this is the number of commands delivered to the Distributor.

For the subscription, this is the number of commands delivered to the Subscriber.

Avg. #Cmds For the Snapshot or Log Reader Agent, this is the average number of commands per transaction delivered to the Distributor for the session.

For the subscription, this is the average number of commands per transaction delivered to the Subscriber for the session.

Move Up Move the selected column higher in the list. It also moves the column to the left in the result pane.
Move Down Move the selected column lower in the list. It also moves the column to the right in the result pane.
Reset Select all the columns and list them in default order.

Show:
© 2014 Microsoft