Deadlock info

Hello,
Does the deadlock information automatically gets written to
the Sql errorlog or do we have enable traces 3604&1204,if we
enable does these flags degrade any performance or does it uses resorces
on the sql server machine.(Anything noticeable)
Thanks in advance.
Hi,
You have to turn on the trace flags so that deadlock victim info is dumped
into the errorlog with more details.DBCC TRACEON will turn the flag on for
that connection and DBCC TRACEOFF will turn it off.I have only used them for
a short period of time, so the performance degradation , if any, was hardly
noticeable.
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"sc" <anonymous@.discussions.microsoft.com> wrote in message
news:C8E78861-6B34-4AEE-97CC-D6ADC30F7DD3@.microsoft.com...
> Hello,
> Does the deadlock information automatically gets written to
> the Sql errorlog or do we have enable traces 3604&1204,if we
> enable does these flags degrade any performance or does it uses resorces
> on the sql server machine.(Anything noticeable)
> Thanks in advance.
>
|||Hi,
No, By default the trace flags are not enabled.
Enabling this trace flag for all users will definitely degrade performance .
But obviously during problem situation you have enable
it for analysis purpose.
Thanks
Hari
MCDBA
"sc" <anonymous@.discussions.microsoft.com> wrote in message
news:C8E78861-6B34-4AEE-97CC-D6ADC30F7DD3@.microsoft.com...
> Hello,
> Does the deadlock information automatically gets written to
> the Sql errorlog or do we have enable traces 3604&1204,if we
> enable does these flags degrade any performance or does it uses resorces
> on the sql server machine.(Anything noticeable)
> Thanks in advance.
>