Quick Tip: Viewing Database Locks in Business Central

I recently discovered this cool feature in Business Central:

The Database Locks page gives snapshot of all current database locks.

To view database locks, open page 9511 Database Locks in the client.

The Database Locks page gives a snapshot of all current database locks in SQL Server. It provides information like the table and database resource affected by the lock. Or, the AL object or method that ran the transaction that caused the lock. These details can help you better understand the locking condition. For an explanation about the fields shown, use the tooltips on the page or refer to sp_lock (Transact-SQL)

I started to prepare my blog and then I noticed this:

So apparently its a new feature in #MSDyn365BC 2020 release wave 1.

Comment List