Is it possible to get the object_name in Blocking processes (Top 10 by Time)?

Kerstin · January 23, 2018 2:08PM

It would be great to be able to see which object is blocked in the Blocking Processes (Top 10 by Time)beta and the picture with the block chain

Adam W · February 7, 2018 1:13PM

Thanks - I've added your suggestion to that Uservoice item so we can make sure we consider it.

Adam W · February 7, 2018 11:19AM

Hi,

We think this sounds like it would be a useful improvement. If you add it as a suggestion on Uservoice and it gets additional support, this would certainly help us prioritise looking further into it.

Were you thinking of something along the lines of how we show this in the Deadlock visualisation below?

Thanks,
Adam

Kerstin · February 7, 2018 12:11PM

I found this registred already: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/17888554-i-wish-the-blocking-process-report-included-the-re I think the suggestion is the same as my idea.

Yes, the wait resource or even better the object_name if applicable would be great to get in the visualisation.

Is it possible to get the object_name in Blocking processes (Top 10 by Time)?

Best Answer

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk