Re: trace 1204

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 07/16/04 

Date: Thu, 15 Jul 2004 20:36:38 -0500

In addition to 1204, you can turn on trace flag 3605 so that the deadlock
diagnostics are written to the SQL Server error log. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Brian Shannon" <bshannon@lbrspec.com> wrote in message
news:efUIFobaEHA.3996@TK2MSFTNGP12.phx.gbl...
> I just enabled this trace to find more information on deadlocks if they
> occur.  Where do I find the information pertaining to this.  Would it be
in
> teh logs?  BOL just talks about enabling it but not where to find the
> detailed info.
>
> Thanks
>
>

Relevant Pages

  • Re: identifying deadlock conditions
    ... Is there any other way to enable the Trace flag 1204 ... Note:- You can also give the same usign SQL server enterprise manager ... "Deadlock" event in the trace file, ...
    (microsoft.public.sqlserver.server)
  • Re: How can I create report after 1024 flag detect a deadlock?
    ... The trace flag to report deadlock is 1204, ... automatically the deadlock information will send to ... How can I create the report what the SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Trace Flag 1204
    ... OK Greg - so, more specifically, I have a test system that, every now and ... However, it doesn't give the entire output that trace flag 1204 would give, ... 1204, likely for some time, until this deadlock occurs, in order to find out ... I am wondering specifically if the performance of the SQL Server will ...
    (microsoft.public.sqlserver.server)
  • Re: Trace Flag 1204
    ... Trace flag 1204 is used to troubleshoot deadlock. ... Generally I would use it to resolve ... It surely has some impact on the SQL Server performance. ...
    (microsoft.public.sqlserver.server)
  • Re: Database is not starting up
    ... I did remove the trace flag and I am positive that I followed the same ... databases, and they were attached. ... and then restart SQL Server. ... Stop and then restart SQL Server. ...
    (microsoft.public.sqlserver.server)