MSmerge_articlehistory (Transact-SQL)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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.

See Also

Replication Tables (Transact-SQL)