Hi Carolyn,

Thank you for your explanation but I think you are only partially correct.

objectlock lockPartition=0 works only partially and cannot find all deadlock situations.

Please look at: https://readuncommitted.com/2012/07/07/deadlocks-involving-lock-partitions/

for details.

Any...

Hi Carolyn,

I like your post and decided to implement this approach in my environment.

Only on e difficulty I got when tested your procedures.

EXEC master.dbo.xp_readerrorlog 0, 1, N'objectlock lockPartition=0',

...