<div>
<div class="content wysiwyg-content">
I'mn using sql2005 std edition, the db is very heavy with insert at every mins and sec's. and due to this behaviors I will plan to ON the read_committed_snapshot. We understands when we use this isolation level it allow us more concurrency. But I heard less disadvantages of using this option. One thing I know it require additional space in Tempdb for Version Store.<br />
Can someone here tell me other advantages of using this option ?<br />
If we have multiple read operation ( same query ) &nbsp;in the database, will it provide us with same results ?
</div>
</div>


I'mn using sql2005 std edition, the db is very heavy with insert at every mins and sec's. and due to this behaviors I will plan to ON the read_committed_snapshot. We understands when we use this isolation level it allow us more concurrency. But I heard less disadvantages of using this option. One thing I know it require additional space in Tempdb for Version Store.
Can someone here tell me other advantages of using this option ?
If we have multiple read operation ( same query )  in the database, will it provide us with same results ?

Disadvantage when set read_committed_snapshot ON in sql2005 std edition

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.