SQL Server Open Read_committed_snapshot

--Querying database status

Select Name,user_access,user_access_desc,                     
Snapshot_isolation_state,
       
       From

--Set the database to Single_user mode to reduce lockout time

ALTER DATABASE SET  with ROLLBACK
ALTER DATABASE SET  on
ALTER DATABASE SET  on
ALTER DATABASE SET Multi_user

Company AX new Project on-line, all posting actions are stuck there, the code did not make any changes, at this point we can check the SQL Server database properties.

Concerns about how the database handles concurrent locks.
When you open the Read_committed_snapshot, the concurrency action becomes normal.

SQL Server Open Read_committed_snapshot