Business Central 2022 wave 2 (BC21) new features: View SQL locks during AL debugging (Locks in Database Statistics)

Dynamics 365 Business Central

Hi, Readers.
The preview environment for Dynamics 365 Business Central 2022 release wave 2 (BC21) is available. Learn more: Link.

I will continue to test and share some new features that I hope will be helpful.

View SQL locks during AL debugging:

Business value:

Understanding database locks when developing and troubleshooting in cloud sandboxes without direct SQL access can be hard. It can be difficult to identify which locks are taken from AL when calling, for example, the rec.Modify() or rec.FindSet() methods. While SQL locks can now be seen in the web client, using this for debugging is cumbersome because you need another browser with another session.

To help with this, the Database Statistics section in the Variables window for the Visual Studio Code AL debugging experience has been extended to show SQL locks for the debugged session.

Two months ago, we just discussed how to view database locks in Business Central. More details: Database Locks.

With 2022 wave 2, Microsoft has brought us more user-friendly feature.

In addition to the last executed SQL statements and database statistics, you can now also get information about active SQL locks occurring during the session, which is being debugged. The list is updated when stepping through AL code.

PS: Commits will remove the held locks.

Give it a try!!!😁

Update from Business Central Launch Event (2022 release wave 2) 


Hope this will help.

Thanks for reading.



Copied title and URL