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.


1
0
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

Description

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