You have implemented code that uses elastic transactions spanning across three different Azure SQL Database logical servers. Database administrators report that some transactions take longer to complete than expected.
You need to use the correct tool to monitor all the transactions originating from the elastic transaction implementation. Which tool should you use?
Use Dynamic Management Views (DMVs) in SQL DB to monitor status and progress of your ongoing elastic database transactions.
These DMVs are particularly useful:
sys.dm_tran_active_transactions: Lists currently active transactions and their status. The UOW (Unit Of Work) column can identify the different child transactions that belong to the same distributed transaction. All transactions within the same distributed transaction carry the same UOW value.
sys.dm_tran_database_transactions: Provides additional information about transactions, such as placement of the transaction in the log.
sys.dm_tran_locks: Provides information about the locks that are currently held by ongoing transactions
Currently there are no comments in this discussion, be the first to comment!