Blocking process tree

Is it possible to get/list the blocking process tree including t-sql, in the monitor ??

Best Answer

  • Alex BAlex B Posts: 1,158 Diamond 4
    Hi @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
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
Sign In or Register to comment.