MSdistribution_history (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

MSdistribution_history (Transact-SQL)

 

Applies To: SQL Server

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

Column nameData typeDescription
agent_idintThe ID of the Distribution Agent.
runstatusintThe Running status:

 1 = Start.

 2 = Succeed.

 3 = In progress.

 4 = Idle.

 5 = Retry.

 6 = Fail.
start_timedatetimeThe time to begin execution of the job.
timedatetimeThe time the message is logged.
durationintThe duration, in seconds, of the message session.
commentsnvarchar(4000)The message text.
xact_seqnovarbinary(16)The last processed transaction sequence number.
current_delivery_ratefloatThe average number of commands delivered per second since the last history entry.
current_delivery_latencyintThe latency between the command entering the distribution database and being applied to the Subscriber since the last history entry. In milliseconds.
delivered_transactionsintThe total number of transactions delivered in the session.
delivered_commandsintThe total number of commands delivered in the session.
average_commandsintThe average number of commands delivered in the session.
delivery_ratefloatThe average delivered commands per second.
delivery_latencyintThe latency between the command entering the distribution database and being applied to the Subscriber. In milliseconds.
total_delivered_commandsbigintThe total number of commands delivered since the subscription was created.
error_idintThe ID of the error in the MSrepl_error system table.
updateable_rowbitSet to 1 if the history row can be overwritten.
timestamptimestampThe timestamp column of this table.

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

Community Additions

ADD
Show:
© 2016 Microsoft