SQL Server Replication and enabling read_committed_snapshot on the distributor RRS feed

  • Question

  • Is there any documentation out there on enabling read_committed_snapshot isolation on the distribution database to reduce contention? I know it is mainly a lot of writes, but there appear to be a fair amount of reads doing some blocking as well. So I am curious if Microsoft has stated anything (since I have been searching and not found anything) or if maybe someone else has done it.

    John M. Couch

    Sunday, June 23, 2013 10:00 AM


All replies