Post reply

Rule of thumb for Transaction Isolation Level usage?

  • February 27, 2011 at 10:08 pm

    #235237

    Sorry, studying for the cert exam, and the examples aren't great in the book...

    Is there a good explanation of scenarios in which one isolation level would be used over another?

    I understand the read uncommitted, read committed ones... it's the more restricted ones that get hard.

    When would a Serializable transaction level be appropriate? I was thinking of a scenario along the lines of a banking transaction. (Partly because it's so trite and relatively easy to understand.)

    If anybody has a website or article somewhere that explains it, that would be awesome.

    Thanks!

    Pieter

  • February 27, 2011 at 10:20 pm

    #1292154

    Found one good article... hopefully it helps someone else... because reading the stuff in the MS book pretty much put me to sleep...

    http://blogs.msdn.com/b/sqlcat/archive/2011/02/20/concurrency-series-basics-of-transaction-isolation-levels.aspx

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

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