Dynamics 365 Business Central Online backend troubleshooting: what I am missing the most.

Shout out to Marije Brummel – De Krosse for her great post about Index packages and to be an inspiration in all of these years (not only for me, I believe). This post is somehow connected to her blog post. Check that out first. The hardest part to work with the online version is due... Continue Reading →

Trend, Forecast and Anomaly detection: time after time.

Always loved Cindy Lauper and the energy of her songs (snif). Well, stop wining and get into the heart of what I would really like to show you: a bit of time analysis and decomposition. NOTE: what will follow could be applied to ANY signal or signal combo. Even applied to custom signals related to... Continue Reading →

Incoming Web Services and API Query : a lesson learned

After several months after upgrading to version 23 in December, one of the API that used to run silently overnight to copy data to Azure Data Lake failed returning HTTP 408 - one of my favorites -. Telemetry on the rescue.   As per documentation, OData / API timeout in SaaS is set to 8... Continue Reading →

EXTERNALDATA operator in telemetry

Last night I said BASTA! That was the last time I would have searched for standard telemetry signal meanings. And I had some fun with it. In a couple of click, I have exported the list of signals from Telemetry Event IDs in Application Insights - Business Central | Microsoft Learn and (abracadabra) transformed into... Continue Reading →

How to spot post-update performance trends in SaaS

What I am experiencing quite often, it is a change – not necessarily a drop – in the performance landscape right after a major or minor update happens. An update is a mix of different changes happening in one single event: Microsoft application changes and data upgrade. Every update takes several thousand lines of new... Continue Reading →

The incredible BULK (INSERT)

Take this trivia quiz. SaaS Version 23.0, 23.1, 23.2, etc. How many SQL Executes it takes to: INSERT 10.000 Records in Sales Line table? INSERT 25.000 Records in Area table? You have 42 seconds to answer (because 42 IS the answer to everything). QUIZ RESOLUTION One feature that was implemented with Dynamics NAV, and now... Continue Reading →

Measuring SaaS UI stability: Standard Deviation and the rollercoaster effect.

Let’s consider pageViews average duration an indicator of good / bad performance within UI. Is this reliable as stand-alone single indicator? NO Take this example. Let’s say that users open a Sales Order 100 times. 50 times it opens in 0.5 seconds, 50 times it opens in 5 seconds. 50 * 0.5 = 25 50... Continue Reading →

The truth about Latency

This is for You. Yes, You. That at least once in a lifetime said, “It works on my machine”. Ah. You haven’t? Are you sure? LIAR! Everybody has (and someone more than once in a lifetime) tested an application in a standalone all-in-one-environment for whatever reason. In this case, exactly the same platform the same... Continue Reading →

My (current) favorites Lego bricks in Telemetry

Telemetry and Lego have many things in common. Both could be collected. And telemetry logs are way cheaper than Lego bricks. If you got kids and it is Xmas time, you perfectly got what I mean.  Now imagine that you have thousands of these Lego components flushed into a big bucket and you must build... Continue Reading →

A new cue in 23.1: love song for a vampire.

Version 23 is like a rose. It smells so good but has its thorn. We moved from 22.5 to 23.1 one of the so-called "Kennie’s elephant" (to be eaten byte after byte) in the cold night of 2nd December. In SaaS, it took 1.5 hours to upgrade this 50+ GB production database. In such dark... Continue Reading →

Blog at WordPress.com.

Up ↑