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)
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru