Replication history

The attrep_history table provides statistics about each task, such as the number and volume of records processed during a particular timeslot.

A new record is appended to the table at the end of each TIMESLOT_DURATION. In other words, the data in this table is never deleted.

Column descriptions
Column	Type	Description
SERVER_NAME	nvchar	The name of the machine on which Replicate is installed.
TASK_NAME	nvchar	The name of the Replicate task.
TIMESLOT_TYPE	varchar	One of the following: FULL LOAD CHANGE PROCESSING (CDC) When FULL LOAD and CHANGE PROCESSING are running in parallel (some tables in full load, some in CDC), two history records will occupy the same time slot.
TIMESLOT	timestamp	The end timestamp of the time slot.
TIMESLOT_DURATION	int	The duration of each history record in minutes.
TIMESLOT_LATENCY	int	The latency at the end of the time slot in seconds. This is only applicable to CDC time slots. Note that this value contains the value of the target latency only.
TIMESLOT_RECORDS	int	The number of records processed during the time slot.
TIMESLOT_VOLUME	int	The volume of data processed in MB.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!