How can we help you today? How can we help you today?

Retrieving Transaction Isolation levels in blocked process reports

There are two methods I have been using to understand blocking situations on our servers:

  • The processes tab in the Blocking Process alert
  • The blocking processes section in the server overview
I can get a lot of information from both of these methods but I don't seem to be able to get the isolation levels of the blocking or blocked queries which would be helpful in understanding why the blocking situation has occurred.

Is there a way I can get this information?
SEarle86
0

Comments

3 comments

Sort by
  • Alex B
    Hi @SEarle86,

    There isn't a specific mechanism to see the transaction isolation level.  This documentation page goes over some scenarios that give indications of which are set based on the behaviour.  Beyond that, you can see the default Transaction Isolation level for the database by using DBCC USEROPTIONS; or, if it is set in the query batch that is blocking or being blocked (i.e. between the GO statements), then it should be shown in the SQL Fragment, otherwise there is not a way to see  this in SQL Monitor I'm afraid.

    I would suggest raising a SQL Monitor Uservoice suggestion.

    Kind regards,
    Alex
    Alex B
    0
  • SEarle86
    Thanks Alex,
    I wasn't aware of the uservoice page and have now raised a suggestion there

    Thanks
    Steve
    SEarle86
    0
  • Alex B
    Hi Steve,

    No worries, thanks for raising that!

    Kind regards,
    Alex
    Alex B
    0

Add comment

Please sign in to leave a comment.