To analyze performances issues in Business Central, top entry points are for sure Telemetry and Troubleshooting Guides delivered as Jupyter Notebooks.
Jupyter Notebooks are provided as .ipynb files (Performance-overview-TSG.ipynb for example) : these files requires Azure Data Studio, kqlmagic library, etc. (with state of the art .ini configuration files :-)
I'm not a big fan of using desktop resources to analyze performance of SaaS environments... so I jumped into online Troubleshooting Guides. This feature is still in preview but quite stable honestly.
The feature is available in the Azure Application Insight resource and fully replace Jupyter Notebooks as you can aggregate KQL queries in a very similar way.
So we went to "copy/paste" existing KQL queries from Jupyter notebooks/samples into a single online Troubleshooting Guide, most of them regarding performance like Long Running queries (RT0005), Database locks (RT0012), AL Performance (RT0018)...
Apart that it's an online feature (with by-design benefits), we liked the ability to consolidate Tenant ID/environments and the usage of Parameters block to filter events on Tenant ID, environment, company, client type, object type/ID, ...
You can obviously mix graphics and data parts, and all data can be downloaded in raw files in case of.
On top of this, it's very easy to deploy as the Troubleshooting guide is a single JSON file that you import into any Azure Tenant/Application Insight resource...
Top comments (0)