sys.dm_repl_tranhash (Transact-SQL)
Applies to:
SQL Server
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.
Permissions for SQL Server 2022 and later
Requires VIEW DATABASE PERFORMANCE STATE permission on the database.
Remarks
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)
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tokom 2024. godine postepeno ćemo ukidati probleme sa uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zameniti ga novim sistemom povratnih informacija. Dodatne informacije potražite u članku:Prosledite i prikažite povratne informacije za