Skip to content

change-tracking-sys-dm-tran-commit-table.md

Latest commit

 

History

History
55 lines (47 loc) · 3.01 KB

change-tracking-sys-dm-tran-commit-table.md

File metadata and controls

55 lines (47 loc) · 3.01 KB

title: "sys.dm_tran_commit_table (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "03/15/2017" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "dmv's" ms.reviewer: "" ms.suite: "sql" ms.technology:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
  • "dm_tran_commit_table"
  • "dm_tran_commit_table_TSQL"
  • "sys.dm_tran_commit_table"
  • "sys.dm_tran_commit_table_TSQL" dev_langs:
  • "TSQL" helpviewer_keywords:
  • "sys.dm_tran_commit_table dynamic management view" ms.assetid: 732d23c5-1f6c-4e96-bc85-8f29b520cf0e caps.latest.revision: 17 author: "stevestein" ms.author: "sstein" manager: "craigg" ms.workload: "Inactive" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"

Change Tracking - sys.dm_tran_commit_table

[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]

Displays one row for each transaction that is committed for a table that is tracked by [!INCLUDEssNoVersion] change tracking. The sys.dm_tran_commit_table management view, which is provided for supportability purposes and exposes the transaction-related information that change tracking stores in the sys.syscommittab system table. The sys.syscommittab table provides an efficient persistent mapping from a database-specific transaction ID to the transaction's commit log sequence number (LSN) and commit timestamp. The data that is stored in the sys.syscommittab table and exposed in this management view is subject to cleanup according to the retention period specified when change tracking was configured.

Note

To call this from [!INCLUDEssSDWfull] or [!INCLUDEssPDW], use the name sys.dm_pdw_nodes_tran_commit_table.

Column name Data type Description
commit_ts bigint A monotonically increasing number that serves as a database-specific timestamp for each committed transaction.
xdes_id bigint A database-specific internal ID for the transaction.
commit_lbn bigint The number of the log block that contains the commit log record for the transaction.
commit_csn bigint The instance-specific commit sequence number for the transaction.
commit_time smalldatetime The time when the transaction was committed.
pdw_node_id int Applies to: [!INCLUDEssSDWfull], [!INCLUDEssPDW]

The identifier for the node that this distribution is on.

See Also

Dynamic Management Views and Functions (Transact-SQL)
About Change Tracking (SQL Server)