| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | f1_keywords | helpviewer_keywords | dev_langs | monikerRange | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sys.dm_tran_aborted_transactions (Transact-SQL) |
sys.dm_tran_aborted_transactions (Transact-SQL) |
rwestMSFT |
randolphwest |
06/19/2023 |
sql |
system-objects |
reference |
|
|
|
>=sql-server-ver15||>=sql-server-linux-ver15||=azuresqldb-mi-current||=azuresqldb-current |
[!INCLUDE SQL Server 2019, ASDB, ASDBMI]
Returns information about unresolved, aborted transactions on the SQL Server instance.
| Column name | Data type | Description |
|---|---|---|
| transaction_id | int | The transaction_id of the aborted transaction. |
| database_id | int | The database_id of the aborted transaction. In [!INCLUDE ssazure-sqldb], the values are unique within a single database or an elastic pool, but not within a logical server. |
| begin_xact_lsn | numeric(25,0) | The starting LSN of the aborted transaction. |
| end_xact_lsn | numeric(25,0) | The ending LSN of the aborted transaction. |
| begin_time | datetime | The begin time of the aborted transaction. |
| nest_aborted | bit | When 1, indicates that the transaction has a nested aborted transaction. |
On [!INCLUDEssNoVersion_md] and SQL Managed Instance, requires VIEW SERVER STATE permission.
On SQL Database Basic, S0, and S1 service objectives, and for databases in elastic pools, the server admin account, the Microsoft Entra admin account, or membership in the ##MS_ServerStateReader## server role is required. On all other SQL Database service objectives, either the VIEW DATABASE STATE permission on the database, or membership in the ##MS_ServerStateReader## server role is required.
Requires VIEW SERVER PERFORMANCE STATE permission on the server.
The sys.dm_tran_aborted_transactions DMV shows all aborted transactions on the SQL Server instance. The nest_aborted column indicates that the transaction has been committed or is active, but there are portions that aborted (savepoints or nested transactions) which can block the PVS cleanup process. For more information, see Troubleshoot accelerated database recovery.
Unresolved, aborted transactions will be removed by the persistent version store (PVS) cleanup process.