MSmerge_articlehistory (Transact-SQL)
The MSmerge_articlehistory table tracks changes made to articles during a Merge Agent synchronization session, with one row for each article to which changes were made. This table is stored in the distribution database.
Column name |
Data type |
Description |
|---|---|---|
session_id |
int |
The ID of a Merge Agent job session in the MSmerge_sessions system table. |
phase_id |
int |
The phase of the synchronization session, which can be one of the following: 1 = Upload. 2 = Download. 4 = Clean-up. 5 = Shutdown. 6 = Schema changes. 7 = BCP. |
article_name |
sysname |
The name of the article to which changes were made. |
start_time |
datetime |
The time when the agent began processing the article. |
duration |
int |
The length of time that the agent processed an article, in seconds. |
inserts |
int |
The number of inserts that have been applied to a specific article during synchronization. This value will increment during the synchronization process, and the ending value represents the total number. |
updates |
int |
The number of updates that have been applied to a specific article during synchronization. This value will increment during the synchronization process, and the ending value represents the total number. |
deletes |
int |
The number of deletes that have been applied to a specific article during synchronization. This value will increment during the synchronization process, and the ending value represents the total number. |
conflicts |
int |
The number of conflicts that occurred during synchronization. This value will increment during the synchronization process, and the ending value represents the total number. |
conflicts_resolved |
int |
The number of conflicts that occurred during synchronization that were resolved. This value will increment during the synchronization process, and the ending value represents the total number. |
rows_retried |
int |
The number of failed rows that were retried during synchronization. This value will increment during the synchronization process, and the ending value represents the total number. |
percent_complete |
decimal |
The percentage of the total synchronization time that the Merge Agent spent on the article during a session. This value is NULL until the session is complete. |
estimated_changes |
int |
An estimate of the number of row changes that must be applied to the article. |
relative_cost |
decimal |
The time spent applying changes for this article versus the total time for the entire session. |