Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam AZ-201 Topic 1 Question 4 Discussion

Actual exam question for Microsoft's AZ-201 exam
Question #: 4
Topic #: 1
[All AZ-201 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

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: ''ase/sql-database-elastic-transactions-overview

Contribute your Thoughts:

Currently there are no comments in this discussion, be the first to comment!

Save Cancel