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:
Do you need to see current database locks for troubleshooting performance issues? In #MSDyn365BC 2020 release wave 1, you can do that in the new Database Locks page: https://t.co/bX60bbj99B pic.twitter.com/mB6NgMZyxJ
— Microsoft Dynamics 365 Business Central (@MSDYN365BC) May 18, 2020
So apparently its a new feature in #MSDyn365BC 2020 release wave 1.