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 ?