What's New: Capturing SQL Calls in Performance Profiles (2025 release wave 2)
SQL call tracking in Business Central performance profiles (2025 release wave 2): the in-client profiler and Visual Studio Code snapshots now show total SQL duration, call count and the actual queries. It works in sampling mode only, not instrumentation mode.
- Introduction and overview
- Profiling recap and in-client profiler history
- Schedule profiles and SQL details feature
- Demo setup and profile capture
- Demo results and SQL insights
- Summary of capabilities
- Support details and resources
Overview
The video recaps the in-client performance profiler and schedule profiles, then covers the added ability to track SQL calls in profiles. It is aimed at helping consultants, developers and support find and troubleshoot SQL issues in customer production environments.
A demo captures a profile and shows that most of the time in a slow flow is spent in SQL, with only a little over one second running AL. The same SQL information can be viewed in Visual Studio Code, where hovering over a call shows the full SQL query, which can be copied. The video also notes that profiling tracks outbound HTTP calls and states that schedule profiles are now the recommended way to profile performance issues.
Key points
- Profiles now show the total duration of SQL calls, the number of calls, and let you drill into the actual SQL queries.
- SQL tracking works in the in-client profiler in the web client and for snapshots captured from Visual Studio Code.
- Only sampling mode is supported; instrumentation mode does not give SQL information.
- SQL information is shown only for AL calls in the call stack captured by sampling.
- In Visual Studio Code, SQL details appear when viewing snapshots or importing profiles; hover over a call to see and copy the full query.
- Schedule profiles capture profiles automatically in the background based on rules a partner sets up, and are now the recommended approach for profiling performance issues.
- Profiling also shows the number and duration of outbound HTTP calls alongside SQL metrics.
Features
| Feature | Status | At |
|---|---|---|
| SQL call tracking in performance profiles | status not stated, demoed | 0:18 |
| Performance profiler in-client tool | status not stated | 1:10 |
| Schedule profiles | status not stated, demoed | 2:38 |
| SQL call visualization in Visual Studio Code | status not stated, demoed | 6:29 |
| HTTP call tracking in performance profiles | status not stated | 5:28 |
Quotes
- 0:18 “In this release, we add the ability to track SQL course calls uh both when using the inclient profiler in the web client as”
- 0:29 “This will help consultants and developers and support to faster identify and troubleshoot SQL issues in customer production environments.”
- 3:03 “The schedule profiles is now the recommended approach uh to profiling performance issues because it’s so easy to set up and analyze afterwards.”
- 6:40 “you can now see which calls are made to SQL during a performance profile and therefore better assess whether bad performance”
- 7:33 “and SQL call information is also available inside of Visual Studio Code. when you’ve done uh snapshots or just by importing the profiles. And”
- 8:44 “Now we only support the sampling mode as I mentioned not instrumentation. uh that means that you only get SQL information for the um”
Presenters (as heard): Peter Boy.