MSmerge_sessions (Transact-SQL)
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
Reference
Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views
Other Resources
Integration Services Tables
Backup and Restore Tables
Log Shipping Tables