Home Forums SQL Server 2008 SQL Server 2008 Administration Enabling RCSI RE: Enabling RCSI

  • December 20, 2017 at 5:16 am

    #1972878

    alex.palmer - Wednesday, December 20, 2017 4:40 AM

    Hi

    I'd like to be able to enable RCSI on some of our databases.

    I know that if your code is not developed to use snapshot isolation then unexpected results can be returned.

    Can anyone offer any advice, or point me to some documentation, on how to test code to see how it reacts to snapshot isolation?

    When I talk to our developers and testers nobody seems to know how to go about this. Is there certain sorts of code and constructs we should look out for?

    Cheers

    Alex

    RCSI is transparent to the user session, it will automatically convert a read committed session to read committed snapshot.
    Note that this isolation level is different to Snapshot Isolation

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉