In-Memory OLTP – Part 12

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.

image

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

Leave a Reply

Your email address will not be published. Required fields are marked *