How to find the blocking duration in sql server?

by jyao   Last Updated July 11, 2019 19:06 PM

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.

Kind regards,


Related Questions

Updated May 14, 2015 05:02 AM

Updated April 02, 2016 08:02 AM

Updated May 24, 2019 15:06 PM

Updated April 11, 2018 14:06 PM

Updated May 16, 2019 21:06 PM