MSdistribution_history (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

The MSdistribution_history table contains history rows for the Distribution Agents associated with the local Distributor. This table is stored in the distribution database.

Definition

Column name Data type Description
agent_id int The ID of the Distribution Agent.
runstatus int The Running status:

1 = Start.

2 = Succeed.

3 = In progress.

4 = Idle.

5 = Retry.

6 = Fail.
start_time datetime The time to begin execution of the job.
time datetime The time the message is logged.
duration int The duration, in seconds, of the message session.
comments nvarchar(4000) The message text.
xact_seqno varbinary(16) The last processed transaction sequence number.
current_delivery_rate float The average number of commands delivered per second since the last history entry.
current_delivery_latency int The latency between the command entering the distribution database and being applied to the Subscriber since the last history entry. In milliseconds.
delivered_transactions int The total number of transactions delivered in the session.
delivered_commands int The total number of commands delivered in the session.
average_commands int The average number of commands delivered in the session.
delivery_rate float The average delivered commands per second.
delivery_latency int The latency between the command entering the distribution database and being applied to the Subscriber. In milliseconds.
total_delivered_commands bigint The total number of commands delivered since the subscription was created.
error_id int The ID of the error in the MSrepl_error system table.
updateable_row bit Set to 1 if the history row can be overwritten.
timestamp timestamp The timestamp column of this table.

See Also

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)