in our application seeing deadlock between 2 stored procedures 1 select , other doing delete. piece makes interesting appear locking same clustered index somehow. there not non-clustered index involved doesn't appear "bookmark loookup deadlock". select appears have shared lock while delete has exclusive lock seems impossible on same index. how possible? below sql profiler deadlock graph:
Comments
Post a Comment