Benifiets/Disadvantages of read_commited_snapshot

May 25, 2008 at 2:16 AM
I've set my PolyMon database to read_commited_snapshot on.  It seems to work without issue and gives quite a few advantages.  Does anyone know of any disadvantages to turning this on?  If not, it seems like it might be a good idea to turn this feature on by default.

"alter database PolyMon set read_committed_snapshot on"

Turning read_committed_snapshot on, makes it use row versioning automatically.  This means that you will always "see" the last transactionally stable view of the database you want to see without any blocking.  Any data changes in progess are not seen by you and don't block you.  Among the advantages is that you don't have as many blocking issues and the job to clean up old events runs better and doesn't prevent new events from being added to the PolyMon database.

Here's some info from Microsoft on how row versioning works.
http://technet.microsoft.com/en-us/library/ms189050.aspx

Thanks :)