Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
MSmerge_sessions (Transact-SQL)
Collapse the table of content
Expand the table of content

MSmerge_sessions (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.

Community Additions

ADD
Show:
© 2015 Microsoft