Transact-SQL Reference
MSdistribution_history
The MSdistribution_history table contains history rows for the Distribution 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 Distribution 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. |
| current_delivery_rate | float | Average number of commands delivered per second since the last history entry. |
| current_delivery_latency | int | Latency between the command entering the distribution database and being applied to the Subscriber since the last history entry. |
| 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 distribution database and being applied to the Subscriber. |
| total_delivered_commands | int | Total number of commands delivered since the subscription was created. |
| error_id | int | ID of the error in the MSrepl_error system table. |
| updateable_row | bit | Set if the history row can be overwritten. |
| timestamp | timestamp | Timestamp column of this table. |