Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

sys.dm_xtp_transaction_stats (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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), SQL Database V12.

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:
© 2015 Microsoft