Blocking process tree
PawJ
Posts: 12 Bronze 1
Is it possible to get/list the blocking process tree including t-sql, in the monitor ??
Tagged:
Best Answer
-
Alex B Posts: 1,158 Diamond 4Hi @PawJ,
There are two places where SQL Monitor has information on the blocking process tree - on the server overview page and on the Blocking Process alert itself.
On the alert, the second tab name Processes shows the blocking tree (here's an example from our online demo):
And there is also a section on the Server Overview for Blocking Processes which will populate if there were any blocking processes in the focus window time period (another example from the online demo):
And when you click on one of the entries in the Blocking Processes (top 10 by time) table it will show you the blocking tree:
I hope that helps, but if I've misunderstood your question, please do clarify and I will try to help further!
Kind regards,
Alex