New answers tagged

-2 just to link sQL servers why would you need MSDTC ? unless the sql servers are using the a distributed transaction in the tsql


Have you tried profiling a single session to see if/when its transaction is promoted to distributed? For example, using a server side trace using e.g. the DTCTransaction (and maybe TM: Promote Tran xxx) event classes. You can also monitor detailed DTC activity in Windows. I would profile all the likely looking connection, execution, and transaction-related ...

Top 50 recent answers are included