Skip to content

Latest commit

 

History

History
74 lines (55 loc) · 3.75 KB

sp-replmonitorhelpmergesessiondetail-transact-sql.md

File metadata and controls

74 lines (55 loc) · 3.75 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs
sp_replmonitorhelpmergesessiondetail (T-SQL)
Returns detailed, article-level information about a specific replication Merge Agent session, which is used to monitor merge replication.
markingmyname
maghan
randolphwest
11/23/2023
sql
replication
reference
sp_replmonitorhelpmergesessiondetail
sp_replmonitorhelpmergesessiondetail_TSQL
sp_replmonitorhelpmergesessiondetail
TSQL

sp_replmonitorhelpmergesessiondetail (Transact-SQL)

[!INCLUDE SQL Server SQL MI]

Returns detailed, article-level information about a specific replication Merge Agent session, which is used to monitor merge replication. The result set includes a detail row for each article that was synchronized during the session. It also includes a row that represents the session initialization and rows that summarize both the upload and download phases of the session. This stored procedure is executed at the Distributor on the distribution database, or at the Subscriber on the subscription database.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

sp_replmonitorhelpmergesessiondetail [ @session_id = ] session_id
[ ; ]

Arguments

[ @session_id = ] session_id

Specifies an agent session. @session_id is int, with no default.

Result set

Column name Data type Description
PhaseID int The phase of the synchronization session, and can be one of the following values:

0 = Initialization or summary row

1 = Upload

2 = Download
ArticleName sysname The name of the article being synchronized. ArticleName also contains summary information for rows in the result set that don't represent article details.
PercentComplete decimal Indicates the percent of the total changes applied in a given article detail row for currently running or failed sessions.
RelativeCost decimal Indicates the time spent synchronizing the article as a percentage of the total synchronization time for the session.
Duration int Length of the agent session.
Inserts int Number of inserts in a session.
Updates int Number of updates in a session.
Deletes int Number of deletes in a session.
Conflicts int Number of conflicts that occurred in a session.
ErrorID int ID of a session error.
SeqNo int Order of sessions in the result set.
RowType int Indicates what type of information each row in the result set represents.

0 = initialization

1 = upload summary

2 = article upload detail

3 = download summary

4 = article download detail
SchemaChanges int Number of schema changes in a session.

Return code values

0 (success) or 1 (failure).

Remarks

sp_replmonitorhelpmergesessiondetail is used to monitor merge replication.

When executed on the Subscriber, sp_replmonitorhelpmergesessiondetail only returns detailed information about the last 5 Merge Agent sessions.

Permissions

Only members of the db_owner or replmonitor fixed database role on the distribution database at the Distributor or on the subscription database at the Subscriber can execute sp_replmonitorhelpmergesessiondetail.

Related content