MSmerge_sessions (Transact-SQL)

 

Applies To: SQL Server

The MSmerge_sessions table contains history rows with the outcomes of previous Merge Agent job sessions. Each time that the Merge Agent is run, a new row is added to this table. This table is stored in the distribution database.

Column nameData typeDescription
session_idintThe ID of the Merge Agent job session.
agent_idintThe ID of the Merge Agent.
start_timedatetimeThe time execution of the job began.
end_timedatetimeThe time execution of the job completed.
durationintThe cumulative duration, in seconds, of this job session.
delivery_timeintThe number of seconds it took to apply a batch of changes.
upload_timeintThe number of seconds it took to upload changes to the Publisher.
download_timeintThe number of seconds it took to download changes to the Subscriber.
delivery_ratefloatThe average number of delivered commands per second.
time_remainingintThe estimated number of seconds left in an active session.
percent_completedecimalThe estimated percent of the total changes that have already been delivered in an active session.
upload_insertsintThe number of inserts applied at the Publisher.
upload_updatesintThe number of updates applied at the Publisher.
upload_deletesintThe number of deletes applied at the Publisher.
upload_conflictsintThe number of conflicts that occurred while applying changes at the Publisher.
upload_conflicts_resolvedintThe number of conflicts that occurred while applying changes at the Publisher that have been resolved.
upload_rows_retriedintThe number of rows being uploaded to the Publisher that were retried.
download_insertsintThe number of inserts applied at the Subscriber.
download_updatesintThe number of updates applied at the Subscriber.
download_deletesintThe number of deletes applied at the Subscriber.
download_conflictsintThe number of conflicts that occurred while applying changes at the Subscriber.
download_conflicts_resolvedintThe number of conflicts that occurred while applying changes at the Subscriber that have been resolved.
download_rows_retriedintThe number of rows being downloaded to the Subscriber that were retried.
schema_changesintThe number of schema changes applied during the session.
metadata_rows_cleanedupintThe number of rows of metadata cleaned-up during the session.
runstatusintThe running status:

 1 = Start.

 2 = Succeed.

 3 = In progress.

 4 = Idle.

 5 = Retry.

 6 = Fail.
estimated_upload_changesintThe estimated number of changes the need to be applied at the Publisher.
estimated_download_changesintThe estimated number of changes the need to be applied at the Subscriber.
connection_typeintThe connection used during upload:

 1 = local area network (LAN).

 2 = dial-up network connection.

 3 = Web synchronization.
timestamptimestampThe timestamp column of this table.

Replication Tables (Transact-SQL)
Replication Views (Transact-SQL)

Community Additions

ADD
Show: