Dynamics 365 Business Central Online Wait Statistics in Telemetry: the AI boost
Wait Statistics in Dynamics 365 Business Central Online provides telemetry data through a Database Wait Statistics page that groups SQL Server wait counters. The post explains how to interpret wait metrics for performance troubleshooting and demonstrates using AI to analyze exported telemetry data from BCPT load testing.
post Dynamics 365 Business Central tales, myths, legends. And something serious.
"Lock wait time is quite serious in this scenario and covers 46% of the time tasks were waiting."
Key points
- Wait Statistics page in Business Central Online emits telemetry showing grouped wait categories with task counts, wait times, signal wait times, and max wait times since last database restart
- Interpreting wait statistics requires calculating deltas between consecutive telemetry snapshots to understand how wait times evolve during a workload
- AI can analyze exported wait statistics telemetry to provide performance insights quickly, making complex SQL Server analysis more accessible
- Lock wait times dominated during inventory posting load tests despite low task counts, accounting for 46% of total wait time
Quotes
- “Lock wait time is quite serious in this scenario and covers 46% of the time tasks were waiting.” (Demonstrates practical use of wait statistics in identifying performance bottlenecks during real workloads like inventory posting.)
AL objects mentioned
As named in the post. A name that matches one object page by exact type and name links to it; the others stay as named.
Context
- Features: Database Wait Statistics page, Emit Telemetry button, Wait category aggregation, Signal wait time tracking, Business Central Performance Toolkit (BCPT), KQL telemetry analysis, AI-assisted performance analysis
Source: Duilio Tacconi, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.