Microsoft Exam AZ-201 Topic 1 Question 4 Discussion

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

References:

https://docs.microsoft.com/en-us/azure/sql-databHYPERLINK 'https://docs.microsoft.com/en-us/azure/sql-database/sql-database-elastic-transactions-overview'ase/sql-database-elastic-transactions-overview