What are the challenges you face when working across database platforms? Take the survey
Options

Blocking Processes - See extra information

Hello Support,

We are using the blocking processes alert to monitor any delay in Application Processing on SQL level. We are seeing a lot of them so were looking to get some extra information about the blocking process. In our opinion it would be very interesting to see what the head blocker process was doing at the time. Is it possible to see the following information abut the blocker:
  • What the wait type is
  • Wait resource
  • How long it has been waiting on this resource
We are currently running version 9.16 of SQL monitor. Is this information available within this version? How can this be retrieved?

Kind regards,

Jogchum Rooda
Tagged:

Answers

  • Options
    Hi Jogchum, 

    Thanks for your post. 

    Have you seen the below documentation page?
    https://documentation.red-gate.com/sm/overview-pages/using-performance-diagnostics#Usingperformancediagnostics-Analyzingwaits
    About halfway down you will find the subheading, Analysing waits. 

    You can find out about:
    • Wait type 
    • Wait description  
    • Waiting tasks - the total number of wait events.
    • Wait time (ms) - the total time (in milliseconds) spent waiting for resource to become available. By default, waits are listed in descending order according to this metric.
    • Avg. wait time - the total time (in milliseconds) spent waiting for resource, divided by the number of waiting tasks.
    • Signal wait time - the total time (in milliseconds) spent waiting in a runnable state once SQL Server has signalled that resource is available. 
    I hope this page is useful, but let us know if you'd like further help.  
    Kind regards

    Robyn Edwards | Redgate Software
    Have you visited our Help Center?
  • Options
    Hi Robyn,

    Thank you for your answer. The link you provided indeed is good information, but i think i was unclear.
    We want to do more in-depth analysis on the blocking processes. But we are having a hard time getting good information out of the alerts. We are missing information about the blocker process. We are seeing the following:



    Sometime we are not seeing the blocked process at all, but when we are seeing a blocked process, we want to see information why the head blocker was taking so long. That's why we need additional information like:
    • What the wait type is that the head blocker is waiting for
    • Wait resource that the head blocker is waiting for
    • How long it has been waiting on this resource
    Is this information that is available in the current version, or do we have to request a change?

    Kind regards,

    Jogchum
  • Options
    Hi does the blocking processes area on the server overview / blocked process not give enough information? It seems to ful-fill what you've requested.
    Have you visited our Help Centre?
Sign In or Register to comment.