Blocking Processes - See extra information
Jogchum_Rooda
Posts: 2 New member
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:
Kind regards,
Jogchum Rooda
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
Kind regards,
Jogchum Rooda
Tagged:
Answers
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.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