Home Dashboard Directory Help
Search

Database Option Enhancement: SET ObjectLockOrderConsistent ON by Graham M1


Status: 

Active


1
0
Sign in
to vote
Type: Suggestion
ID: 773502
Opened: 12/5/2012 1:12:17 AM
Access Restriction: Public
0
Workaround(s)
view

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...
Details
Sign in to post a comment.
Posted by Microsoft on 1/16/2013 at 1:17 PM
Thanks for the feedback, we are reviewing this issue
Sign in to post a workaround.