MSmerge_articlehistory (Transact-SQL)

 

Applies To: SQL Server

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 nameData typeDescription
session_idintThe ID of a Merge Agent job session in the MSmerge_sessions system table.
phase_idintThe 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_namesysnameThe name of the article to which changes were made.
start_timedatetimeThe time when the agent began processing the article.
durationintThe length of time that the agent processed an article, in seconds.
insertsintThe 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.
updatesintThe 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.
deletesintThe 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.
conflictsintThe number of conflicts that occurred during synchronization. This value will increment during the synchronization process, and the ending value represents the total number.
conflicts_resolvedintThe 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_retriedintThe 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_completedecimalThe 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_changesintAn estimate of the number of row changes that must be applied to the article.
relative_costdecimalThe time spent applying changes for this article versus the total time for the entire session.

Replication Tables (Transact-SQL)

Community Additions

ADD
Show: