Do you remember this screen from classic client where in we can find who has locked whom.
Once we get blocking id then we try to kill those sessions using sql command .
How to view such detail in business central.
This view detail information like which object id and which function is causing the database locks.
Hope this will help you.
Stay tuned for more updates.