track blocking processes date/time by start time, not login time
in blocking tree, it shows old date/times for queries that are running. We found that it is using the login time of the spids (which could be held and sleeping for extended amount of time) instead of the start time of the executing process of that spid.
instead of using the login time, I recommend it uses the start time of the last execution of the query found in sys.dmexecrequest
1
vote
Ed
shared this idea