sys-dm-xtp-transaction-stats-transact-sql.md

title	sys.dm_xtp_transaction_stats (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	08/09/2016
ms.prod	sql
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	dm_xtp_transaction_stats_TSQL dm_xtp_transaction_stats sys.dm_xtp_transaction_stats_TSQL sys.dm_xtp_transaction_stats
dev_langs	TSQL
helpviewer_keywords	sys.dm_xtp_transaction_stats dynamic management view
ms.assetid	9389f48d-0de5-47bd-9821-4db8f04504e4
author	stevestein
ms.author	sstein

sys.dm_xtp_transaction_stats (Transact-SQL)

[!INCLUDEappliesto-ss-asdb-xxxx-xxx-md]

Reports statistics about transactions that have run since the server started.

For more information, see In-Memory OLTP (In-Memory Optimization).

Column name	Data type	Description
total_count	bigint	The total number of transactions that have run in the In-Memory OLTP database engine.
read_only_count	bigint	The number of read-only transactions.
total_aborts	bigint	Total number of transactions that were aborted, either through user or system abort.
user_aborts	bigint	Number of aborts initiated by the system. For example, because of write conflicts, validation failures, or dependency failures.
validation_failures	bigint	The number of times a transaction has aborted due to a validation failure.
dependencies_taken	bigint	Internal use only.
dependencies_failed	bigint	The number of times a transaction aborts because a transaction on which it was dependent aborts.
savepoint_create	bigint	The number of savepoints created. A new savepoint is created for every atomic block.
savepoint_rollbacks	bigint	The number of rollbacks to a previous savepoint.
savepoint_refreshes	bigint	Internal use only.
log_bytes_written	bigint	Total number of bytes written to the In-Memory OLTP log records.
log_IO_count	bigint	Total number of transactions that require log IO. Only considers transactions on durable tables.
phantom_scans_started	bigint	Internal use only.
phatom_scans_retries	bigint	Internal use only.
phantom_rows_touched	bigint	Internal use only.
phantom_rows_expiring	bigint	Internal use only.
phantom_rows_expired	bigint	Internal use only.
phantom_rows_expired_removed	bigint	Internal use only.
scans_started	bigint	Internal use only.
scans_retried	bigint	Internal use only.
rows_returned	bigint	Internal use only.
rows_touched	bigint	Internal use only.
rows_expiring	bigint	Internal use only.
rows_expired	bigint	Internal use only.
rows_expired_removed	bigint	Internal use only.
rows_inserted	bigint	Internal use only.
rows_updated	bigint	Internal use only.
rows_deleted	bigint	Internal use only.
write_conflicts	bigint	Internal use only.
unique_constraint_violations	bigint	Total number of unique constraint violations.

Permissions

Requires VIEW SERVER STATE permission on the server.

See Also

Memory-Optimized Table Dynamic Management Views (Transact-SQL)