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?

    sjackson, Oct 3, 2007
    #2

  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
    bradmcgehee, Oct 4, 2007
    #3

Share This Page