Add the calling module/process in "Blocking process" alerts
In the Details tab of a Blocking Process alert the process name of the blocking process is included. It would be very useful if this was included in the "Blocked process" info on the processes tab. This would assist us in working out what it is that the blocked process is trying to access because the SQL fragment is often too generic to be useful.
From version 12.1.28 this information is provided.
-
Anonymous commented
Greate idea! We do need also see the SSIS package name
-
Volker Brandauer commented
Great idea! Maybe also in a structured way like an Explorer with who is the blocking process and wwho has been blocked. Would be very helpful for me.