Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Trace why a transaction is escalated to DTC

Is there any way to determine precisely why a System.Transaction TrasactionScope is being escalated to the DTC? We are hitting a bump with one of our components that seem to escalate the transaction while all other components (which seem deceptively similar) does not do escalation.

Are any information made available on the reasons for the escalation and how can they be found and observed? SQL Profiler? Log files? Or am I out of luck on this one?

UPDATE: I'm running against SQL Server 2005 for info

like image 655
soren.enemaerke Avatar asked Feb 03 '09 11:02

soren.enemaerke


People also ask

What are escalated transactions?

Transaction management escalation describes the process of migrating a transaction from one of the transaction manager's components to another. System. Transactions includes a transaction manager component that coordinates a transaction involving at most, a single durable resource or multiple volatile resources.

Why do we need DTC?

Direct to consumer is exactly what it is, selling directly to end customers. The strategy behind this approach is that it bypasses wholesalers and retailers, thus cutting out unnecessary costs associated with having intermediaries between manufacturers and the consumer.

What is Msdtc service?

The Microsoft Distributed Transaction Coordinator (MSDTC) service is a component of modern versions of Microsoft Windows that is responsible for coordinating transactions that span multiple resource managers, such as databases, message queues, and file systems.


1 Answers

When using TransactionScope a transaction is escalated whenever application opens a second connection (even to the same database) within the Transaction Scope in question.

like image 182
Anton Gogolev Avatar answered Sep 21 '22 09:09

Anton Gogolev