We are getting a nasty deadlock problem.
I've got the Server Error log and I'm looking at the Deadlock trace dump from the Server log. The same table and stored procedure shows everytime, which is good. And it shows how the processes are owning one resource and waiting on another resource. And it shows for each process involved, the statement involved.
My question is, the statement it shows, is that the statement where the process acquired the resource, or where the process is waiting for the other resource? Is there a way to determine both statements?