Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Important
Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned
| Enabled for | Public preview | General availability |
|---|---|---|
| Admins, makers, marketers, or analysts, automatically | Oct 2025 | Oct 2025 |
Business value
Understanding SQL performance when troubleshooting in the cloud without direct SQL access can be hard. Now you have the capability to track SQL calls, both when using the in-client profiler in the web client as well as when capturing snapshots from Visual Studio Code. This will help consultants and developers to faster identify and troubleshoot SQL issues in customer production environments, providing a better customer experience.
Feature details
You can now see which calls are made to SQL during a performance profile, and therefore better assess whether bad performance is due to AL code inefficiencies or resulting SQL calls.
SQL call information is supported both in profiles captured in the client (interactively or via scheduled profiling), and Visual Studio Code via snapshots. Note that only sampling mode is supported, so this needs to be set for the Visual Studio Code snapshot capture—it's the only mode supported in-client and therefore implicitly set there.
For scheduled profiles, in the Performance Profiles overview page you can see the total duration of captured SQL calls in partner code, number of calls, and the duration of platform calls.
When drilling into a specific profile, you can see the actual SQL calls that are made. You can hover over them and copy the queries.
Geographic areas
Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.
Language availability
Visit the Explore Feature Language report for information on this feature's availability.
Tell us what you think
Help us improve Dynamics 365 Business Central by discussing ideas, providing suggestions, and giving feedback. Use the forum at https://aka.ms/bcideas.