Blocking Process Alert to be based on Blocking Time
This idea has been posted before but marked as closed, so posting again. For blocking process alert, it would be good to have the option to setup the alert in a way where we can report on the duration when the first and last blocking happened and if it exceeds a certain threshold.
Let's say, we have set the threshold for 90 seconds and if there are three processes that have wait time of 30 seconds each, that totals to 90 seconds, we receive an alert. However, we don’t want to receive an alert for the 30 second blocked processes. We only want to receive the alert if the max duration of blocking exceeds 90 seconds on any one of the descendants.