Home Forums SQL Server 2017 SQL Server 2017 - Administration Readable Secondary Node and Isolation Level RE: Readable Secondary Node and Isolation Level

  • December 1, 2017 at 5:49 am

    #1970244

    alex.palmer - Friday, December 1, 2017 2:48 AM

    Hi

    I've been looking into using availability groups in our environment.  I've read that if the secondary is readable then all selects execute with snapshot isolation.

    That is correct, the impact of row versioning is mentioned in my stairway at this link

    http://www.sqlservercentral.com/articles/stairway/107542/

    alex.palmer - Friday, December 1, 2017 2:48 AM

    Does this mean that the queries need to be written to run with snapshot isolation or suffer from unreliable results as detailed by Craig Freeman here?

    All queries are converted to snapshot automatically

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

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