Normally the info comes out in the expected format but over the last few day
s
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


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


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


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


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


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


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


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


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


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 d
ays
> 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


> 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


> 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


> 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


> 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


> 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


> 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


> 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


> 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


>|||Mike, I know this flag is set as I set it. What I dont get are these are ver
y
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:
[vbcol=seagreen]
> 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:
>|||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...[vbcol=seagreen]
> 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 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...
>
>
No comments:
Post a Comment