It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×6,076
×4,288
×1
×1

question asked: Jul 31 '12, 4:50 p.m.
question was seen: 3,457 times
last updated: Jul 31 '12, 10:50 p.m.

Related questions

FAQ - How this Forum works

Requirement for setting row versioning to READ_COMMITTED

0
Kevin Cool (1●2●4●4) | 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

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Benjamin Silverman (4.1k●6●10) | answered Jul 31 '12, 10:50 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
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.