sys.dm_repl_tranhash (Transact-SQL)

APPLIES TO: YesSQL Server NoAzure SQL Database NoAzure Synapse Analytics (SQL DW) NoParallel Data Warehouse

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.


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.

See Also

Dynamic Management Views and Functions (Transact-SQL)
Replication Related Dynamic Management Views (Transact-SQL)