Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Finding the Header Blocker from Application Insights Telemetry

Posted on by 55

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:
  • Suggested answer
    Andy Sather Profile Picture
    Andy Sather on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,228 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans