Odd deadlock info in errorlog

We have a server where we are actively monitoring deadlocks at the moment.
Normally the info comes out in the expected format but over the last few days
the messages have occasionally been truncated(See end of message)
Is this normal behaivour, I've never seen entries like this before.
Thanks.
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:8 Ec:(0x3F442098) Value:0x42beb8d0 Cost:(0/2710)
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec:(0x40088098) Value:0x42beb92c Cost:(0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:6 Ec:(0x3F270098) Value:0x42beb1a0 Cost:(0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:7 Ec:(0x408EC098) Value:0x42beb1fc Cost:(0/2710)
2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)Hi
Trace Flag 1204 has been set.
Search SQL Server BOL for "Trace Flag 1204" for more information.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Watson" wrote:
> We have a server where we are actively monitoring deadlocks at the moment.
> Normally the info comes out in the expected format but over the last few days
> the messages have occasionally been truncated(See end of message)
> Is this normal behaivour, I've never seen entries like this before.
> Thanks.
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:8 Ec:(0x3F442098) Value:0x42beb8d0 Cost:(0/2710)
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
> 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec:(0x40088098) Value:0x42beb92c Cost:(0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:6 Ec:(0x3F270098) Value:0x42beb1a0 Cost:(0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:7 Ec:(0x408EC098) Value:0x42beb1fc Cost:(0/2710)
> 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
>|||Mike, I know this flag is set as I set it. What I dont get are these are very
truncated messages and not the usual pageful of info that is normally
generated.
(The messages all came in one block, I've not edited out anything here)
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Trace Flag 1204 has been set.
> Search SQL Server BOL for "Trace Flag 1204" for more information.
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Mike Watson" wrote:
> > We have a server where we are actively monitoring deadlocks at the moment.
> > Normally the info comes out in the expected format but over the last few days
> > the messages have occasionally been truncated(See end of message)
> >
> > Is this normal behaivour, I've never seen entries like this before.
> >
> > Thanks.
> >
> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:8 Ec:(0x3F442098) Value:0x42beb8d0 Cost:(0/2710)
> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:5 Ec:(0x40088098) Value:0x42beb92c Cost:(0/2710)
> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:6 Ec:(0x3F270098) Value:0x42beb1a0 Cost:(0/2710)
> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:7 Ec:(0x408EC098) Value:0x42beb1fc Cost:(0/2710)
> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND' SPID:70
> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> >|||See http://support.microsoft.com/?id=832524 for additional info. This
behaviour is normal.
Adrian
"Mike Watson" <MikeWatson@.discussions.microsoft.com> wrote in message
news:E3EC85DA-B1E2-46D6-AC82-C0BA20FDB459@.microsoft.com...
> Mike, I know this flag is set as I set it. What I dont get are these are
> very
> truncated messages and not the usual pageful of info that is normally
> generated.
> (The messages all came in one block, I've not edited out anything here)
> "Mike Epprecht (SQL MVP)" wrote:
>> Hi
>> Trace Flag 1204 has been set.
>> Search SQL Server BOL for "Trace Flag 1204" for more information.
>> --
>> --
>> Mike Epprecht, Microsoft SQL Server MVP
>> Zurich, Switzerland
>> MVP Program: http://www.microsoft.com/mvp
>> Blog: http://www.msmvps.com/epprecht/
>>
>> "Mike Watson" wrote:
>> > We have a server where we are actively monitoring deadlocks at the
>> > moment.
>> > Normally the info comes out in the expected format but over the last
>> > few days
>> > the messages have occasionally been truncated(See end of message)
>> >
>> > Is this normal behaivour, I've never seen entries like this before.
>> >
>> > Thanks.
>> >
>> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
>> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:8 Ec:(0x3F442098) Value:0x42beb8d0 Cost:(0/2710)
>> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
>> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:5 Ec:(0x40088098) Value:0x42beb92c Cost:(0/2710)
>> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
>> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
>> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:6 Ec:(0x3F270098) Value:0x42beb1a0 Cost:(0/2710)
>> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:7 Ec:(0x408EC098) Value:0x42beb1fc Cost:(0/2710)
>> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
>> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
>> > SPID:70
>> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
>> >|||Hi Adrian,
I couldn't find in that link an explanation of that short version of
deadlock entry in errorlog
"Adrian Zajkeskovic" wrote:
> See http://support.microsoft.com/?id=832524 for additional info. This
> behaviour is normal.
> Adrian
>
> "Mike Watson" <MikeWatson@.discussions.microsoft.com> wrote in message
> news:E3EC85DA-B1E2-46D6-AC82-C0BA20FDB459@.microsoft.com...
> > Mike, I know this flag is set as I set it. What I dont get are these are
> > very
> > truncated messages and not the usual pageful of info that is normally
> > generated.
> >
> > (The messages all came in one block, I've not edited out anything here)
> >
> > "Mike Epprecht (SQL MVP)" wrote:
> >
> >> Hi
> >>
> >> Trace Flag 1204 has been set.
> >>
> >> Search SQL Server BOL for "Trace Flag 1204" for more information.
> >> --
> >> --
> >> Mike Epprecht, Microsoft SQL Server MVP
> >> Zurich, Switzerland
> >>
> >> MVP Program: http://www.microsoft.com/mvp
> >>
> >> Blog: http://www.msmvps.com/epprecht/
> >>
> >>
> >>
> >> "Mike Watson" wrote:
> >>
> >> > We have a server where we are actively monitoring deadlocks at the
> >> > moment.
> >> > Normally the info comes out in the expected format but over the last
> >> > few days
> >> > the messages have occasionally been truncated(See end of message)
> >> >
> >> > Is this normal behaivour, I've never seen entries like this before.
> >> >
> >> > Thanks.
> >> >
> >> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
> >> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:8 Ec:(0x3F442098) Value:0x42beb8d0 Cost:(0/2710)
> >> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:7 Ec:(0x402F8098) Value:0x42beba40 Cost:(0/2710)
> >> > 2005-06-09 15:46:12.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:46:12.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:5 Ec:(0x40088098) Value:0x42beb92c Cost:(0/2710)
> >> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> >> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> >> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:6 Ec:(0x3F270098) Value:0x42beb1a0 Cost:(0/2710)
> >> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:7 Ec:(0x408EC098) Value:0x42beb1fc Cost:(0/2710)
> >> > 2005-06-09 15:47:42.00 spid4 Victim Resource Owner:
> >> > 2005-06-09 15:47:42.00 spid4 ResType:ExchangeId Stype:'AND'
> >> > SPID:70
> >> > ECID:5 Ec:(0x4047E098) Value:0x42beb258 Cost:(0/2710)
> >> >
>
>