Microsoft KB Archive/61653

= INFO: Two-Phase and Three-Phase Commit Information =

Article ID: 61653

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition

-



This article was previously published under Q61653



SUMMARY
The clearest explanation of two-phase and three-phase commits is in Ullman's &quot;Baseball Database&quot; book. The reference to this publication does not represent a recommendation by Microsoft to use this book as a database reference; however, the information regarding two-phase and three-phase commits is helpful to understand these concepts.



MORE INFORMATION
Two-phase commit is defined to be the following:

A participant commits when it knows that all other participants have voted to commit.

Three-phase commit is defined to be the following:

A participant commits when it knows that all other participants know that all participants have voted to commit.

The extra phase reduces the amount of time that locks must be held if a failure occurs. Any participant that had received a commit or abort message can respond to a &quot;help-me&quot; message from a participant that is unsure of the state of the transaction. It is not necessary to hold all the locks until the coordinator gets back up.

Keywords: kbinfo kbother KB61653

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.