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

title	sys.dm_tran_commit_table (Transact-SQL)
description	Change Tracking - sys.dm_tran_commit_table
author	rwestMSFT
ms.author	randolphwest
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database
ms.technology	system-objects
ms.topic	reference
f1_keywords	dm_tran_commit_table dm_tran_commit_table_TSQL sys.dm_tran_commit_table sys.dm_tran_commit_table_TSQL
helpviewer_keywords	sys.dm_tran_commit_table dynamic management view
dev_langs	TSQL
ms.assetid	732d23c5-1f6c-4e96-bc85-8f29b520cf0e
monikerRange	=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current||>=aps-pdw-2016||=azure-sqldw-latest

Change Tracking - sys.dm_tran_commit_table

[!INCLUDE sql-asdb-asdbmi-asa-pdw]

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. [!INCLUDEsynapse-analytics-od-unsupported-syntax]

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)