Occurs when a task is waiting to acquire a Shared lock on the current key value, and an Exclusive Range lock between the current and previous key. For a lock compatibility matrix, see sys.dm_tran_locks (Transact-SQL).
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.
- Google Search for sqlserver - LCK_M_RX_S
- Ecosia Search for sqlserver - LCK_M_RX_S
- Bing Search for sqlserver - LCK_M_RX_S