Advice here
Check if RCSI is enabled
SELECT name,
is_read_committed_snapshot_on
FROM sys.databases
WHERE name = DB_NAME();
Enable RCSI
ALTER DATABASE YOURDATABASE SET READ_COMMITTED_SNAPSHOT ON GO
Do a full index rebuild on everything after enabling it
--------------------------------------
Related
------------------------------------
Also consider enabling ADR, and Optimized locking if you are on SQL 2019+
