Working out what transaction isolation level a transaction is running under from extended events

• DominantDBA

  SSC Eights!

  Points: 862

  More actions

  July 25, 2014 at 8:47 am

  #309453

  Hi Ive got a standard extended event running capturing rpc_completed and sql_batch_completed

  I want to do analysis by transaction and wanted to know how you figure out what isolation level a transaction is running under?

  Does anyone know where I can get this info?

  thanks

  Chris

• DominantDBA

  SSC Eights!

  Points: 862

  More actions

  July 28, 2014 at 4:57 am

  #1732750

  Anyone? There must be a way?

• DominantDBA

  SSC Eights!

  Points: 862

  More actions

  July 28, 2014 at 5:42 am

  #1732774

  If anybody is interested I came across this that recommends using the blocked process report in EX:

  http://www.sqlskills.com/blogs/joe/tracking-isolation-level/

  Its annoying that the extended event transaction information doesnt extend to isolation level