Why does the database freeze when INSERT, UPDATE through application software?

Question

SQL Server

Good afternoon. Prompt - there is a DB, it is twisted on SQL EXPRESS 2008 R2, everything is all right.
There is a base on 6 (six) regions. 5 work fine, 6 APPLICATION freezes when trying to insert a record\save changes (even there are no changes)
In the database itself, the data is saved.
I opened the triggers, commented out the trigger for UPDATE (that is, I left only BEGIN - END), but the situation has not changed.
At the same time, I checked the database through BDCHECK - there are no errors.
What you can see: - what are the server system logs, logs for a specific database?
The application shell is the same for all databases, it is on a certain database that the execution of commands hangs, which will be performed quietly on other databases - I think that the problem is in the database

Answer 1

MS SQL has a log:
But it's better to install a control system SQL Server Toolsand use a profiler.
And one more thing: SSMS has reports. For example, "blocking transactions", "long-running transactions, "transactions blocking other transactions", etc.