Monitor XTP Transaction
Couple of dmv’s where provided to monitor In-Memory transactions
GO SELECT * FROM sys.dm_db_xtp_transactions GO SELECT * FROM sys.dm_xtp_transaction_recent_rows GO SELECT * FROM sys.dm_xtp_transaction_stats GO
sys.dm_db_xtp_transactions : Reports the active transactions in the In-Memory OLTP database engine.
The result of this transaction will have below possible values.
0 – IN PROGRESS
1 – SUCCESS
2 – ERROR
3 – COMMIT DEPENDENCY
4 – VALIDATION FAILED (RR)
5 – VALIDATION FAILED (SR)
6 – ROLLBACK
sys.dm_xtp_transaction_stats:Reports statistics about transactions that have run since the server started.