New answers tagged msdtc
http://blogs.msdn.com/b/alwaysonpro/archive/2014/01/15/msdtc-recommendations-on-sql-failover-cluster.aspx 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