All Questions
1 question
9
votes
1
answer
2k
views
Shared locks taken under Read Committed Snapshot Isolation (RCSI)
I am seeing waits for shared locks (LCK_M_S) when using RCSI. My understanding is that this isn't supposed to happen since SELECTs do not require shared locks when using RCSI.
How can I be seeing ...