I'm getting LCK_M_S on read_committed_snapshot isolation. From my understanding, this isn't supposed to happen since my selects are not placing shared locks anymore.
From my logs, I can see that my database are blocking on select statements, why am I getting this?
What is the possibility that I get LCK_M_S on read_committed snapshot? Is this because of foreign keys?
Also does select place shared locks as well during foreign key validation on read committed snapshot isolation?