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.