Finding the Header Blocker from Application Insights Telemetry

(0) Share

Report

Posted on by D Curd

I've been trying to use the example KQL queries at BCTech/LockTimeouts.kql at master · microsoft/BCTech · GitHub to investigate some performance issues. Using that script I've got a query that has errored due to a lock timed out, which is great as this would have taken a lot of effort to find in older versions. It also shows the locks in place after the error occurred. However, it doesn't seem to show which queries were head blockers. Does anyone have any suggestion how to get that information? At the moment I am looking at the AL code in the blocked function, checking what table it uses and then looking for update locks on that table in the lock snapshot. Does anyone know of a better way?

Categories:

Business Central

All responses (1)

Answers (0)

Suggested answer

Andy Sather on at

Like (0)

Report

RE: Finding the Header Blocker from Application Insights Telemetry

Hello - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

I will open this up to the community in case they have something to add.