Hi Microsoft,
We seek an easier way to troubleshoot "Performance" issues in Business Central, like the tools we had available in older versions (Classic NAV)
Today in Business Central we only have long term telemetry showing blockings and usage patterns which can be very helpful in providing input for optimizations of workflows at a customer site with the aim of reducing issues with concurrency.
However, what is very often much more directly felt by the customer is specific examples of bad coding. A typical example could be that it takes a very long time to open a certain page or that updating a certain field value on a sales line will make the system freeze for half a minute.
Such issues are in most cases not rooted in concurrency issues and thus it could be argued that this is not really related to “performance”. Nevertheless, to the customer this is a major contributor to a general impression that the system is performing poorly.
To find out what is causing excess run time in a given scenario, we need to be able to collect detailed data that will reveal what is going on. The experience so far with the performance profiles in BC has been that the data we can retrieve does not contain the details we need to effectively expose the root cause.
In the Classic NAV we had two important tools; Client Monitor and Code Coverage.
Could similar tools be available for Business Central SaaS?
Comments
It is great that you are using the profiler for investigating performance issues. We are aware of current gaps, such as more insights into actual SQL calls and outbound http call performance, but can you expand a bit on the scenarios where the profiler does not provide enough information, and the old client monitor/code coverage tools did?For code coverage, are you aware that the snapshot debugger replay (i.e., the one used to capture a profile from VSCode) can show a quick overview of lines of code actually hit? This is somewhat similar to code coverage, although simpler. See https://learn.microsoft.com/en-us/dynamics365-release-plan/2022wave2/smb/dynamics365-business-central/visualize-code-lines-executed-snapshot-captureThanks, Peter (Microsoft)
Category: General
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team