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 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.|