hi Gail, yes there are other transactions (one insert on the parent table policy) then there are few updates on the other child tables. After that this insert happens in...

yep.. me too puzzled why this is happening.. here is the sqlplan & also the lock information when this insert is executed..

Hi Gail,

Update stats & rebuild of indexes are happening on a daily basis.

Ok. Thanks Gail for your help.

Hi Gail,

Any observation?

Regards,

Ganesh

Name ...

here is the deadlock info

ResType:LockOwner Stype:'OR'Xdes:0x0000000151736370 Mode: S SPID:114 BatchID:0 ECID:0 TaskProxy:(0x00000001FA2DE598) Value:0x4166a200 Cost:(0/22380)

Victim Resource Owner:

Log Viewer could not read information for this log entry. Cause: Data is Null....