Trace flag in deadlock

  • Ryan007

    SSCrazy Eights

    Points: 8273

    Comments posted to this topic are about the item Trace flag in deadlock

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • M&M

    SSC-Insane

    Points: 21699

    Thanks for the question. I got it wrong as I misread 'non-XML' as 'XML'. So, I chose 1222.

    M&M

  • This was removed by the editor as SPAM

  • Stuart Davies

    SSCoach

    Points: 18878

    mohammed moinudheen (9/14/2011)


    Thanks for the question. I got it wrong as I misread 'non-XML' as 'XML'. So, I chose 1222.

    Know what you mean - do'h.

    Still should teach me to read the question at least twice before answering like I was told in school

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a questionThere are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan I would never join a club that would allow me as a member - Groucho Marx

  • DugyC

    Hall of Fame

    Points: 3804

    Great question, but I got it wrong because I jumped too quick and didn't properly think it through.

    I deliberately chose 1222 because it "Returns the resources and types of locks that are participating in a deadlock and also the current command affected, in an XML format that does not comply with any XSD schema."

    My wrong :doze:

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • TomThomson

    SSC Guru

    Points: 104773

    DugyC (9/15/2011)


    Great question, but I got it wrong because I jumped too quick and didn't properly think it through.

    I deliberately chose 1222 because it "Returns the resources and types of locks that are participating in a deadlock and also the current command affected, in an XML format that does not comply with any XSD schema."

    My wrong :doze:

    It's a nice question.

    I didn't fall into the trap of choosing 1222, but that was more luck than anything else, as according to the detecting and ending deadlocks page 1222 doesn't produce XML but "an XML-like format". Good old BoL, contradicting itself again. It also claims that SQL 2008 records information in the SQL 2005 error log, which seems unlikely to be correct.

    Tom

  • george sibbald

    SSC Guru

    Points: 104200

    trouble is 1222 returns the info in a much easier to read format, so we should be encouraging people to use that trace flag rather than 1204.

    thats my point back. 🙂

    ---------------------------------------------------------------------

  • george sibbald

    SSC Guru

    Points: 104200

    It also claims that SQL 2008 records information in the SQL 2005 error log, which seems unlikely to be correct.

    thats why I can't find any deadlock info !

    ---------------------------------------------------------------------

  • rfr.ferrari

    SSCertifiable

    Points: 6879

    very good question!!!


    [font="Times New Roman"]rfr.ferrari[/font]
    DBA - SQL Server 2008
    MCITP | MCTS

    remember is live or suffer twice!
    the period you fastest growing is the most difficult period of your life!
  • Britt Cluff

    SSCertifiable

    Points: 5083

    Good question, thanks for submitting.

    http://brittcluff.blogspot.com/

  • Jason Wolfkill

    SSCrazy Eights

    Points: 9772

    Tom.Thomson (9/15/2011)


    DugyC (9/15/2011)


    Great question, but I got it wrong because I jumped too quick and didn't properly think it through.

    I deliberately chose 1222 because it "Returns the resources and types of locks that are participating in a deadlock and also the current command affected, in an XML format that does not comply with any XSD schema."

    My wrong :doze:

    It's a nice question.

    I didn't fall into the trap of choosing 1222, but that was more luck than anything else, as according to the detecting and ending deadlocks page 1222 doesn't produce XML but "an XML-like format". Good old BoL, contradicting itself again. It also claims that SQL 2008 records information in the SQL 2005 error log, which seems unlikely to be correct.

    Plus, the example of trace flag 1222's output provided on the page Tom mentioned doesn't look anything like XML. I would say that "XML-like" != "XML" (using the non-ANSI "not equal to" operator to avoid formatting hassles caused by the "angle bracket"/"greater than" and "less than" symbols)!

    Jason Wolfkill

  • SQLRNNR

    SSC Guru

    Points: 281243

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Ken Wymore

    SSCoach

    Points: 16612

    Nice question, thanks

  • CoolCodeShare

    SSCrazy

    Points: 2584

    Good Question!

  • ChrmnMAO

    Say Hey Kid

    Points: 675

    Good question! Thanks!

Viewing 15 posts - 1 through 15 (of 17 total)

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