Post reply

Results of trace 1204?

  • August 12, 2005 at 12:20 pm

    #87098

    I ran dbcc traceon (1204) to get deadlock information and used

    dbcc tracestatus(-1) to ensure that it was enabled. I then used some statements found on this forum to successfully force a deadlock in Northwind. Then I turned off the trace flag with dbcc traceoff (1204). Where did the "report" go (i.e. the details of the deadlock)? I see the trace going on and off in the current SQL Server log, but nothing in between as I expected.

  • August 12, 2005 at 3:13 pm

    #582007

    i was doing it by session. i'm going to try it by server (changing the startup parameter).

  • August 12, 2005 at 3:23 pm

    #582009

    You have to run DBCC TRACEON in order to the other connections see the new trace flag.

    From BOL:

    DBCC TRACEON

    "...New connections into the server do not see any trace flags until a DBCC TRACEON statement is issued. Then, the connection will see all trace flags currently enabled in the server, even those enabled by another connection."

     

  • August 15, 2005 at 12:44 am

    #582076

    The 'report' of deadlock activity goes in the current SQL Server Errorlog. Regarding traceflags, see my article How to use trace flags in SQL Server 2000.

    --
    Chris Hedgate http://www.hedgate.net/
    Contributor to the Best of SQL Server Central volumes
    Articles: http://www.sqlservercentral.com/columnists/chedgate/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply