See Transaction Isolation Levels in Blocking Alerts
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.
Prior to using SQL monitor, we used the blocked process report to monitor blocking and these include the isolation levels. Unfortunately, I still have to resort to using these to get this information - it would be easier to keep all this within SQL Monitor
This information is invaluable as it helps to understand why certain locks have been taken, which may not be otherwise immediately obvious
Is there a way I can get this information?