MSdistribution_history (Transact-SQL)

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

Reference

Replication Views (Transact-SQL)

Concepts

Replication Tables (Transact-SQL)