Deadlocks between different processes holding locks on different "Lock Partition" - by SQL_Jay

Status : 

  Duplicate<br /><br />
		This item appears to be a duplicate of another existing Connect or internal item.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 794154 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 7/16/2013 12:29:30 PM
Access Restriction Public


We have this very busy oltp system running sql 2008 sp3 cu2. The server has 32 cores allocated to it. We are frequently encountering deadlocks between multiple processes. The deadlock graph shows two processes deadlocked between different lock partitions on the same object . I have attached the deadlock graphs, replaced the table names in this case.

Since the select needs schema stability locks, and ddl(disable tigger) needs schema modification locks we can understand blocking but since we cannot disable lock partitioning we end up having a deadlock. Please suggest what to do in this case. We have seen many deadlocks like this in the past few months.
Sign in to post a comment.
Posted by Microsoft on 7/17/2013 at 4:46 PM
Thanks for submitting this feedback. We plan to address this in the next version of SQL Server.