deadlock analize with SQL Server Profiler - IX Lock while executing select statements

124 views Asked by At

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:

  1. How could it happen that select statement causes deadlocks?
  2. How could it happen that select statement has IX mode?
0

There are 0 answers