sys.dm_repl_tranhash (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Returns information about transactions being replicated in a transactional publication.

Applies to: SQL Server (SQL Server 2008 through current version).
column_namedata_typedescription
bucketsbigintNumber of buckets in the hash table.
hashed_transbigintNumber of committed transactions replicated in the current batch.
completed_transbigintNumber of transactions competed so far.
compensated_transbigintNumber of transactions that contain partial rollbacks.
first_begin_lsnnvarchar(64)Earliest begin log sequence number (LSN) in the current batch.
last_commit_lsnnvarchar(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.

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

Community Additions

ADD
Show: