Export (0) Print
Expand All

sys.dm_repl_tranhash (Transact-SQL)

Returns information about transactions being replicated in a transactional publication.

Applies to: SQL Server (SQL Server 2008 through current version).

column_name

data_type

description

buckets

bigint

Number of buckets in the hash table.

hashed_trans

bigint

Number of committed transactions replicated in the current batch.

completed_trans

bigint

Number of transactions competed so far.

compensated_trans

bigint

Number of transactions that contain partial rollbacks.

first_begin_lsn

nvarchar(64)

Earliest begin log sequence number (LSN) in the current batch.

last_commit_lsn

nvarchar(64)

Last commit LSN in the current batch.

Requires VIEW DATABASE STATE permission on the publication database to call dm_repl_tranhash.

Information is only returned for replicated database objects that are currently loaded in the replication article cache.

Community Additions

ADD
Show:
© 2014 Microsoft