It's all about the answers!

Ask a question

Requirement for setting row versioning to READ_COMMITTED

Kevin Cool (1244) | asked Jul 31 '12, 4:50 p.m.
The documentation says it is required to set row versioning on database to READ_COMMITTED Snapshot to ON and this will have huge impact on TempDB.  Why is it necessary to set this option apart from reducing locks. 

One answer

permanent link
Benjamin Silverman (4.1k610) | answered Jul 31 '12, 10:50 p.m.
Hi Kevin,

This article indicates that turning on READ_COMMITTED_SNAPSHOT increases concurrency as well as reducing deadlocks.  It is an optimization setting which does impact the size of the tempdb.  Testing has revealed significant performance improvements and reduced locks with the row level versioning enabled.  See this WI for details.  Hope it helps,

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.