I wish the blocking Process report included the resource the Blocked processes are waiting on.
My Dev write 500+ line procedures and functions so the SQL "Fragment" is seldom very helpful.
It would be much more helpful to identify the resources the processes are blocked on. Even just the waitresource and waittype columns from sys.dmexecrequests would help.
I know some of the resource types are tough to parse in T-SQL.
-
SAinCA_Mi9 commented
TWO AND A HALF YEARS since this was requested. The Blocking Alert for a Stored Proc of any significant size is useless for any kind of blocking-detection. When is this going to get sorted, please?
-
Adding another suggestion relating to this:
"The wait resource or even better the object_name if applicable would be great to get in the Blocking Processes (Top 10 by Time) visualisation.
-
Stephen A commented
Totally agree - except I'm dealing with 3000 line complex, multi-table insert-updates for batches of calculations. I have no idea whatsoever which resource is involved...