To reduce locks and blocks in the SQL Server configuring SysTrack database to READ_COMMITTED_SNAPSHOT is supported. Screenshot attached for ref.
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTEDSS
Score:0.0 (0)