MSdistribution_history (T-SQL)

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

Column name Data type Description
agent_id int ID of the Distribution Agent.
runstatus int Running status:
0 = Start
2 = Succeed
3 = In progress
4 = Idle
5 = Retry
6 = Fail
start_time datetime Time to begin execution of the job.
time datetime Time the message is logged.
duration int Duration, in seconds, of the message session.
comments nvarchar(255) Message text.
xact_seqno varbinary(16) Last processed transaction sequence number.
current_delivery_rate float Average number of commands delivered per second since the last history entry.
current_delivery_latency int Latency between the command entering the distribution database and being applied to the Subscriber since the last history entry.
delivered_transactions int Total number of transactions delivered in the session.
delivered_commands int Total number of commands delivered in the session.
average_commands int Average number of commands delivered in the session.
delivery_rate float Average delivered commands per second.
delivery_latency int Latency between the command entering the distribution database and being applied to the Subscriber.
total_delivered_commands int Total number of commands delivered since the subscription was created.
error_id int ID of the error in the MSrepl_error system table.
updateable_row bit Set if the history row can be overwritten.
timestamp timestamp Timestamp column of this table.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.