Hi Gail,

My confusion is:

If both update and select are part of the same transaction. and update is having a X lock on the data rows, IX lock on the index page and table. Then when select requires a shared lock on the data row will it be able to acquire?

What i have understood (or misunderstood :doze:) from the topic is select will not be able to acquire the shared lock if the data row is protected by an X lock from the Update statement neither can have a IS on clustered index pages nor on table as those are already protected by IX locks.

Now the statement which says if the select statement acquires enough locks to trigger lock escalation and the escalation succeeds the IX lock on the table is converted to X lock. Now if the table is protected by X lock how select will succeed?

Thanks

Dev