Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

MSlogreader_history (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Community Additions

ADD
Show:
© 2015 Microsoft