Database Option Enhancement: SET ObjectLockOrderConsistent ON - by Graham M1

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<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 773502 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 12/5/2012 1:12:17 AM
Access Restriction Public


Add a new database option:

SET ObjectLockOrderConsistent  ON

When this option is on the locks requested by any TSQL statements are always requested in object_id sorted order.

This will eliminate deadlocks - if all queries ask for resources in the same order.
I imagine it is too hard.  I imagine that the query engine would need an overhaul, but if you could do it it would be fantastic. It would be the end of deadlocks  - a major headache.

 Just dreaming...
Sign in to post a comment.
Posted by Vishal [MSFT] on 1/16/2013 at 1:17 PM
Thanks for the feedback, we are reviewing this issue