Blocking process report does not display database name
I would like to see databasename and also starttime and endtime in the blocked process report. It qwould also bee good to be able to scale the picture in size.
kerstin
shared this idea
-
Mark Freeman
commented
I would like to see Start and End columns or a Duration column, along with a Blocked Process Count.
When displaying the Process tab on the detail page, it would be helpful for each blocked process to display as a collapsed line in a tree, each branch of which can be expanded. Each line should display the SessionId, Start and End or Duration, and the Application, Host, User, and the first (n) characters of the SQL fragment. It is great to have all the details available, but I currently get one huge page with no navigation for one blocker (see attached) and it is very difficult to visualize the blocking tree to determine cause, effect, and duration, or even just to see everything that is impacted.
Documentation on how SQL Sentry handles this in their web interface:
https://documentation.solarwinds.com/en/success_center/sqlsentry/content/sqlsentry-portal/blocking.htm#:~:text=the%20%E2%96%BA%20arrow%20to-,expand%20the%20row,-and%20view%20the