Post reply

isolation level

  • March 6, 2009 at 6:36 am

    #126854

    Can anyone say whether serialization isolation level is prone to deadlock??

  • March 6, 2009 at 8:19 am

    #954920

    What do you mean "prone to deadlock"?

    Did you mean SERIALIZABLE isolation level?

    -- Gianluca Sartori

  • March 6, 2009 at 8:55 am

    #954966

    Samrat Sen (3/6/2009)

    Can anyone say whether serialization isolation level is prone to deadlock??

    Transactions running under serializable are more likely to deadlock than any other, because of the extend of the locks taken and the length of time they're held. In general, the higher the isolation level, the more the chance of blocking and deadlocks

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply