figuring out deadlocks

mrQQmrQQ Member Posts: 239
edited 2013-05-16 in SQL General
hi,

So this one installation is getting a lot of deadlocks. Most of them are on Reservation Entry. I can catch them with Profiler, but the graph shows somethings strange, both SPIDs requesting exact same KEY. How can I figure out the lock order of previously locked tables? Half of the queries are called through WebService, so the SPIDs always change, and I can't run Client Monitor on that.


I've attached a sample graph.

https://skydrive.live.com/redir?resid=B ... 4orOIKoou8

Comments

  • rmv_RUrmv_RU Member Posts: 119
    Attachment is not available. Could you post keys in Reservation Entry table?
    Unoptimized key can cause big locking problems, especially for versions early than Nav 4.0 SP3.
    Looking for part-time work.
    Nav, T-SQL.
  • mrQQmrQQ Member Posts: 239
    http://sdrv.ms/13o6Eyt

    i'm not talking about long blocking, i'm talking about deadlocks..
Sign In or Register to comment.