MSlogreader_history

Transact-SQL Reference

Transact-SQL Reference

MSlogreader_history

The MSlogreader_history table contains history rows for the Log Reader 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 Log Reader 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.
delivery_time int Time first transaction is delivered.
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 published database and being entered into the distribution database.
error_id int ID of the error in the MSrepl_error system table.
timestamp timestamp Timestamp column of this table.