MSlogreader_history (Transact-SQL)

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.

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.