and in temporary tables?

Is optimized locking enabled?

See

Is optimized locking enabled?

If RCSI is enabled, use the

table hint to force blocking between two queries

when optimized locking is enabled.

No, because DML statements can’t run on read-only replicas, and the corresponding row and

page locks aren’t taken.

Not at this time.

Transaction locking and row versioning guide

Read committed snapshot isolation (RCSI)

sys.dm_tran_locks (Transact-SQL)

Accelerated database recovery