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 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)
Opinia
https://aka.ms/ContentUserFeedback.
Dostępne już wkrótce: W 2024 r. będziemy stopniowo wycofywać zgłoszenia z serwisu GitHub jako mechanizm przesyłania opinii na temat zawartości i zastępować go nowym systemem opinii. Aby uzyskać więcej informacji, sprawdź:Prześlij i wyświetl opinię dla