MSmerge_sessions (Transact-SQL)

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

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 name Data type Description
session_id int The ID of the Merge Agent job session.
agent_id int The ID of the Merge Agent.
start_time datetime The time execution of the job began.
end_time datetime The time execution of the job completed.
duration int The cumulative duration, in seconds, of this job session.
delivery_time int The number of seconds it took to apply a batch of changes.
upload_time int The number of seconds it took to upload changes to the Publisher.
download_time int The number of seconds it took to download changes to the Subscriber.
delivery_rate float The average number of delivered commands per second.
time_remaining int The estimated number of seconds left in an active session.
percent_complete decimal The estimated percent of the total changes that have already been delivered in an active session.
upload_inserts int The number of inserts applied at the Publisher.
upload_updates int The number of updates applied at the Publisher.
upload_deletes int The number of deletes applied at the Publisher.
upload_conflicts int The number of conflicts that occurred while applying changes at the Publisher.
upload_conflicts_resolved int The number of conflicts that occurred while applying changes at the Publisher that have been resolved.
upload_rows_retried int The number of rows being uploaded to the Publisher that were retried.
download_inserts int The number of inserts applied at the Subscriber.
download_updates int The number of updates applied at the Subscriber.
download_deletes int The number of deletes applied at the Subscriber.
download_conflicts int The number of conflicts that occurred while applying changes at the Subscriber.
download_conflicts_resolved int The number of conflicts that occurred while applying changes at the Subscriber that have been resolved.
download_rows_retried int The number of rows being downloaded to the Subscriber that were retried.
schema_changes int The number of schema changes applied during the session.
metadata_rows_cleanedup int The number of rows of metadata cleaned-up during the session.
runstatus int The running status:

1 = Start.

2 = Succeed.

3 = In progress.

4 = Idle.

5 = Retry.

6 = Fail.
estimated_upload_changes int The estimated number of changes the need to be applied at the Publisher.
estimated_download_changes int The estimated number of changes the need to be applied at the Subscriber.
connection_type int The connection used during upload:

1 = local area network (LAN).

2 = dial-up network connection.

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

See Also

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