How to find the blocking duration in sql server?

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

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,

jeff_yao



Related Questions


SQL Blocking causing timeouts

Updated May 14, 2015 05:02 AM


Blocked Process Report

Updated May 24, 2019 15:06 PM

Blocking SPID has Zero Disk IO and Zero CPU Time

Updated April 11, 2018 14:06 PM