September 26, 2003 at 12:30 pm
My error logs are filled with this error, every morning at the same time. Any idea what this means? Is this a locking issue?
TIA,
Aurora
September 29, 2003 at 8:00 am
This was removed by the editor as SPAM
September 29, 2003 at 10:08 am
What's the exact error? Is this because of a deadlock?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
August 8, 2008 at 9:00 am
I also have this problem and am guessing it is because of deadlocks:
2008-08-08 10:19:48.39 spid4 Victim Resource Owner:
2008-08-08 10:19:48.39 spid4 ResType:ExchangeId Stype:'AND' SPID:496 ECID:2 Ec:(0x7978A0C0) Value:0x42e51d20 Cost:(0/270F)
2008-08-08 10:19:48.39 spid4 Victim Resource Owner:
2008-08-08 10:19:48.39 spid4 ResType:ExchangeId Stype:'AND' SPID:496 ECID:2 Ec:(0x7978A0C0) Value:0x42e51d20 Cost:(0/270F)
2008-08-08 10:19:48.39 spid4 Victim Resource Owner:
2008-08-08 10:19:48.39 spid4 ResType:ExchangeId Stype:'AND' SPID:496 ECID:2 Ec:(0x7978A0C0) Value:0x42e51d20 Cost:(0/270F)
2008-08-08 10:19:48.39 spid4 Victim Resource Owner:
2008-08-08 10:19:48.39 spid4 ResType:ExchangeId Stype:'AND' SPID:496 ECID:2 Ec:(0x7978A0C0) Value:0x42e51d20 Cost:(0/270F)
2008-08-08 10:19:48.39 spid4 Victim Resource Owner:
2008-08-08 10:19:48.39 spid4 ResType:ExchangeId Stype:'AND' SPID:496 ECID:3 Ec:(0x7979A0C0) Value:0x42e51988 Cost:(0/270F)
2008-08-08 10:20:03.39 spid4 Victim Resource Owner:
2008-08-08 10:20:03.39 spid4 ResType:ExchangeId Stype:'AND' SPID:496 ECID:2 Ec:(0x428880C0) Value:0x42e516a8 Cost:(0/270F)
2008-08-08 10:20:28.39 spid4 Victim Resource Owner:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply