Post reply

Deadlock Trace Flag question.

  • July 5, 2006 at 1:38 pm

    #168828

    Can anybody tell me what is the difference between DBCC traceon(3604) and dbcc traceon(3605) and similarily differnece between DBCC traceon(1204) and dbcc traceon(1205).Any help is appreciated.

    Thanks,

    SR

    Thanks,
    SR

  • July 5, 2006 at 11:53 pm

    #647673

    -- 1204 Returns the type of lock participating in the deadlock and the current command affect by the deadlock.

    -- 1205 Returns more detailed information about the command being executed at the time of a deadlock.

    -- 1206 Used to complement flag 1204 by displaying other locks held by deadlock parties

    -- 3604 Sends trace output to the client. Used only when setting trace flags with DBCC TRACEON and DBCC TRACEOFF.

    -- 3605 Sends trace output to the error log. 

    we have added -T1204 and -T3605 to the startupparameters of all our sqlservers (7.0 an 2000) so we (prod-dba) get a look into deadlocks and can support a solution.

    with SQL2005 we use -T1222 and -T3605.

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • July 6, 2006 at 7:03 am

    #647738

    Thanks a lot for you response.Its very helpful.

     

    Thanks,

    SR

     

    Thanks,
    SR

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

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