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 |
| 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. |