I run SQL Server Profiler and saw that I have some deadlocks. When I opened deadlock graph I could see that only select statements are in that graph. For many pagelocks waiter and owner has the same "S" mode. For some pagelocks owner has "IX" mode but when I looked at that process execution stack - it is select statement with isolationlevel="read committed (2)".
Here I have two questions:
- How could it happen that select statement causes deadlocks?
- How could it happen that select statement has IX mode?