Verbose Telemetry: a potential online SQL Profiler

Dynamics 365 ERP - Development

On-Premises allows full control and responsibility for the backend, including access to the database and detailed tracing with tools like SQL Server Profiler.
Online versions lack tools like SQL Server Profiler, but Verbose Telemetry can provide detailed SQL statement execution data.
Enabling Verbose Telemetry in Dynamics 365 Business Central can help troubleshoot issues in real-time.
Verbose Telemetry sends signals with high priority to aid troubleshooting efforts.
Caution should be exercised when enabling Verbose Telemetry as it sends every single SQL statement to the ingestion point, potentially impacting ingestion costs.
A KQL query can mimic the On-Premise SQL Server Profiler to analyze SQL statements and AL StackTrace correlation.
Verbose Telemetry can help optimize code by filtering out Microsoft extensions and focusing on AppSource apps and Per Tenant Extensions.
Optimization strategies can include adjusting IsolationLevel, evaluating the necessity of columns and FlowFields, and optimizing specific patterns for better performance.

Registered users can view the full text for FREE!