MSlogreader_history (Transact-SQL)

Applies to: yesSQL Server (all supported versions)

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 The ID of the Log Reader 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(255) The message text.
xact_seqno varbinary(16) The last processed transaction sequence number.
delivery_time int The time first transaction is delivered.
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 published database and being entered into the distribution database. In milliseconds.
error_id int The ID of the error in the MSrepl_error system table.
timestamp timestamp The timestamp column of this table.
updateable_row bit Set to 1 if the history row can be overwritten.

See Also

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