Software Design, Architecture Microsoft .Net & SQL Server solutions!

Tag: atomic

THE Microsoft Distributed Transaction Coordinator (MSDTC) is a pretty nifty tool in every Windows system. What this tool allows is that it enables applications to make use of Transactions (and all its glory) when communicating across distributed systems. MSDTC provides the same atomic properties of single a Transaction – but the overhead of maintaining Transactional atomicity across these distributed system is managed internally by the MSDTC.

But…There is always a ‘but’…

What if you are building a system that operates on one Server? Alot of small to medium sized applications would fall into this category. As an example: Consider one transactional system that spans across many Databases that lie on the same Database Server. Would you still need, or perhaps want, the MSDTC to handle your transactions?

In this article I will explain how certain situations may misuse MSDTC escalations, and how it is possible for you to avoid it…