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?
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.
I will open this up to the community in case they have something to add.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156