Trace flag in deadlock

Question

Post reply

Trace flag in deadlock

Ryan007

SSCrazy Eights

Points: 8275
More actions
September 14, 2011 at 9:47 pm

#257353

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//
September 15, 2011 at 1:10 am

This was removed by the editor as SPAM

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

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

M&M SSC-Insane Points: 21700 More actions · Answer 1

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

M&M

Stuart Davies SSCoach Points: 19505 More actions · Answer 2

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 question
There 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 More actions · Answer 3

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 More actions · Answer 4

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: 104210 More actions · Answer 5

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: 104210 More actions · Answer 6

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 More actions · Answer 7

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 More actions · Answer 8

Good question, thanks for submitting.

http://brittcluff.blogspot.com/

Jason Wolfkill SSCrazy Eights Points: 9832 More actions · Answer 9

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: 281334 More actions · Answer 10

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