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.

One Thought on “Quick Tip: Viewing Database Locks in Business Central

  1. Armondz on May 20, 2020 at 09:45 said:

    hm, page can be found in NAV 2018 also…

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Post Navigation