Home Forums SQL Server 2005 SQL Server 2005 General Discussion Why are my transactions running in SERIALIZABLE isolation level? RE: Why are my transactions running in SERIALIZABLE isolation level?

  • November 20, 2014 at 1:23 am

    #1759733

    Jeff Moden (11/19/2014)

    My thought would be that you're spending a whole lot of time on something that might not help.

    In this case I'd disagree. Serialisable, when used unnecessarily, can easily cause deadlocks that would not occur in any other isolation level

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass