Redigera

Dela via


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

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)