SQL Server Performance

Strange Deadlocking... any ideas?

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by sjackson, Oct 3, 2007.

  1. sjackson New Member

    I'm working on a strange problem since a couple of hours. My application is creating high numbers of granted exclusive locks in transactions on the same object id - at least according to MS SQL Activity Monitor.

    Can anyone explain to me how it is possible to create more than on granted (e.g. Request Status=GRANT) and exclusive lock (e.g. RequestMode=X) on the same objects?? OwnerType is TRANSACTION.
    Any ideas how to debug this issue?

  2. bradmcgehee New Member

    Use Profiler to identify your locking issues. If you have not done so, read up on these Profiler events:
    • Deadlock
    • Deadlock Chain
    • Deadlock Graph

Share This Page