sys.dm_repl_tranhash (Transact-SQL)

Returns information about transactions being replicated in a transactional publication.

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.

Permissions

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.