MSlogreader_history (Transact-SQL)


Applies To: SQL Server

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 nameData typeDescription
agent_idintThe ID of the Log Reader 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(255)The message text.
xact_seqnovarbinary(16)The last processed transaction sequence number.
delivery_timeintThe time first transaction is delivered.
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 published database and being entered into the distribution database. In milliseconds.
error_idintThe ID of the error in the MSrepl_error system table.
timestamptimestampThe timestamp column of this table.
updateable_rowbitSet to 1 if the history row can be overwritten.

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

Community Additions