Launching the AL debugger not only allows you to step through the code to debug data and logic flow, but it also lets you view vital SQL information that will help you to diagnose performance-related problems.

As you are debugging, you will be able to see the 10 most recent SQL queries that were executed. For on-premise installations, you can configure the server and set the number of statements you can see.

You are able to view the following information for the recent SQL queries:

• Statement: The SQL statement that was generated by the AL code
• Execution Time: The time (UTC) at which the statement was executed
• Duration: The length of time (milliseconds) it took to execute the query
• Rows Read: The number of rows the query processed

In addition to viewing the recent SQL queries, the debugger also shows you some statistics for the current debugging session:

• SQL Latency: The time (milliseconds) it takes to execute a SQL statement, which is measured when a breakpoint is hit
• Number of SQL Executes: The total number of SQL statements that have been executed in the current debugging session
• Number of SQL Row Reads: The number of rows read from the database in the current debugging session