sys.dm_xtp_transaction_stats (Transact-SQL)

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance

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.
system_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.
phantom_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.

Permissions for SQL Server 2022 and later

Requires VIEW SERVER PERFORMANCE STATE permission on the server.

See also

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