Game-Changer for Business Central Developers: Deep Dive into SQL Performance!

By : Abhinav Saini | Technical Head

If you're a Dynamics 365 Business Central developer or technical consultant, you've likely faced this challenge: a page is running slow, and you're left guessing. Is it inefficient AL code, or is a poorly performing SQL query the real culprit? Troubleshooting in a cloud environment without direct SQL access has always been a black box... until now.

Microsoft is rolling out a much-anticipated feature in the October 2025 release wave that brings incredible transparency to performance tuning: the ability to view SQL call information directly in performance profiles.

This is a massive leap forward for identifying and resolving performance bottlenecks in customer environments.

What's New?

You can now see the exact SQL calls being made during a performance profiling session. This is supported both when using the in-client profiler and when capturing snapshots from Visual Studio Code.

Here’s a quick look at what this new capability offers:

• High-Level Overview: The Performance Profiles page now shows you the total duration of captured SQL calls, the number of calls, and the duration of platform calls at a glance. You can immediately see if SQL is a significant factor in the activity's duration.

• Detailed Call Tree Analysis: This is where the magic happens. When you drill into a specific profile, you can see the individual SQL statements in the call tree. You can even hover over a query and copy it for further analysis. No more guesswork!

Why This Matters

• Faster Troubleshooting: Pinpoint whether performance issues stem from your AL logic or the resulting database queries, drastically reducing time spent on diagnostics.
• Code Optimization: Gain a deeper understanding of how your AL code translates to SQL. This insight empowers you to write more efficient and performant extensions from the start.
• Improved Customer Experience: By resolving performance issues more quickly and effectively, you provide a better, smoother experience for end-users.

Availability: This feature is planned for Public Preview and General Availability in October 2025.

This is a fantastic addition to the developer toolkit, providing the visibility we need to build and maintain high-performing Business Central environments.

What are your thoughts on this new feature? How will it change your troubleshooting workflow? Let me know in the comments below!

#MSDyn365 #BusinessCentral #ALDev #PerformanceTuning #SQL #MicrosoftDynamics

Need help optimizing your Business Central environment or preparing for the latest updates? Our team at SQIT Consulting is here to assist.

• Phone: +971-45897017 / +971-589800163
• Email: sales@sqitconsulting.com
• Web: www.sqitconsulting.com