Distributed Transactions
If you have decided to get into the distributed transaction business to support your high availability requirements, it will be extremely important for you to understand the distributed ”unit of work” logical transaction concept. In other words, you need a way to ensure that the distributed transaction operates in the same way that a local transaction does, and that it adheres to the same ACID properties of a local transaction, across multiple servers.
Microsoft has implemented its distributed transaction processing capabilities based on the industry standard two-phase commit protocol. As mentioned earlier in this chapter, it utilizes the distributed transaction coordinator service (MS DTC) as the controller of this capability. ...
Get Microsoft® SQL Server High Availability now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
