Row Versioning Concurrency in SQL Server
Posted
on Simple Talk
See other posts from Simple Talk
Published on Thu, 05 Jun 2014 00:00:00 GMT
Indexed on
2014/06/06
15:36 UTC
Read the original article
Hit count: 129
T-SQL Programming
The optimistic concurrency model assumes that several concurrent transactions can usually complete without interfering with each other, and therefore do not require draconian locking on the resources they access. SQL Server 2005, and later, implements a form of this model called row versioning concurrency. It works by remembering the value of the data at the start of the transaction and checking that no other transaction has modified it before committing. If this optimism is justified for the pattern of activity within a database, it can improve performance by greatly reducing blocking. Kalen Delaney explains how it works in SQL Server.
© Simple Talk or respective owner