snapshot isolation

• msimone

  SSCommitted

  Points: 1846

  More actions

  June 30, 2014 at 6:29 am

  #308678

  Hello.

  Is a good idea to use this behavior in a busy OLTP?

  What is the best for that case, snapshot or read_committed_snapshot?

  Thanks.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  June 30, 2014 at 10:24 am

  #1725932

  The answer to both of those is 'test it'

  Read committed snapshot can be very useful, you have to test and make sure that the overhead on TempDB isn't too bad. You also need to test and ensure that you have no code which is depending on locking behaviour (eg queue-type apps)

  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