Replication Server can create rs_threads with row-level lock when the replicate database is Microsoft SQL Server. By default, the row-level lock is “on” and page level lock is “on”. For external commit control method, we need to have only row-level locking. When you apply a row-level lock to a table, you must grant unique index or primary key to that table. For example:
create table rs_threads (id int,seq int CONSTRAINT PK_rs_threads PRIMARY KEY CLUSTERED(id ASC) WITH (ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = OFF))
When the isolation level is 3, use:
Select seq from rs_threads with(nolock) where id =?
For more information on selecting isolation levels for your transactions, see Chapter 4, “Performance Tuning,” in the Replication Server 15.5 Administration Guide - Volume 2.
