identify blocking sql no longer executing, but didnt commit transaction
I want to be able to see the blocking statemement of a session that is done executing a statment, but did not commit the transaction. It seems that the "blocking Statment" is missing in the blockchain, if the statement causing the block is no longer executing. This leads me to think that your currently pulling the sqlhandle of the blocking session, whereas the more , or at least sometimes more appropiate think to do is to pull the "mostrecentsqlhandle" from sqltext. please consider.
1
vote
Jørgen Christiansen
shared this idea
-
Jørgen Christiansen commented
check this example