Debugging SQL

Typically, when you are debugging your Business Central application, you're doing it to move through the AL code in order to trace data or find a logic error. However, you are also able to use the debugger to analyze the SQL statements that your AL code generates, with the goal of identifying performance problems.

This recipe will show you how to debug SQL statements using the AL language debugger.

Getting ready

You're going to need an AL project to work in that's connected to a development sandbox. We will continue to build on the Television Show project that we've been working with in the previous chapters. If you have not completed all of the chapters, download the project from the GitHub...