Export (0) Print
Expand All

sys.dm_xtp_transaction_stats (Transact-SQL)

SQL Server 2014

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

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

Applies to: SQL Server (SQL Server 2014 through current version).

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.

Requires VIEW SERVER STATE permission on the server.

Community Additions

ADD
Show:
© 2014 Microsoft