We know that there is a "blocked_process_report" event, which will be fired once the blocked session is blocked longer than a threshold defined by
sp_configure 'blocked process threshold'
However, it seems there is no corresponding "unblocking" event, so if want to find the blocking duration for a specific blocking event, what should I do?
I know we can use
sys.dm_index_operational_stats to get some aggregated blocking duration data, but it is not accurate/detailed enough for me.
Thanks for your help.