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 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)
प्रतिक्रिया
https://aka.ms/ContentUserFeedback.
जल्द आ रहा है: 2024 के दौरान हम सामग्री के लिए फीडबैक तंत्र के रूप में GitHub मुद्दों को चरणबद्ध तरीके से समाप्त कर देंगे और इसे एक नई फीडबैक प्रणाली से बदल देंगे. अधिक जानकारी के लिए, देखें:के लिए प्रतिक्रिया सबमिट करें और देखें