Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

MSdistribution_history

SQL Server 2000

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 name Data type Description
agent_id int ID of the Distribution Agent.
runstatus int Running status:

1 = 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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.