Trace Flags 1204 and 1205 output changed?

Question

Trace Flags 1204 and 1205 output changed?

KitKaterina

Ten Centuries

Points: 1122
More actions
July 31, 2008 at 11:56 am

#123647

Hi All
I'm a long time lurker - this is my first post, so hello and I hope you can help! 😀
I have just enabled trace flags 1204 and 1205 on a new server, which is at SQL Server 2000 SP4. Funny thing is I am not seeing the output which I expected to see in the event log, I'm not seeing KEY, TAB or PAG references, and also nothing from the buffer.
Has anyone else experienced anything similar? Has anyone got any ideas how to get all the detail back in the output from these trace flags?

Viewing 6 posts - 1 through 5 (of 5 total)

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

Carl Federl One Orange Chip Points: 25384 More actions · Answer 1

The 1204 and 1205 only collect information about deadlocks but to write the information to the SQL Server log file, you need to include -T3605

SQL = Scarcely Qualifies as a Language

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

1204 and 1205 write deadlock graphs and associated info into the SQL error log. If you aren't having deadlocks, you won't see anything written. I wouldn't usually suggest using both. 1204 is usually good enough for identifying deadlocks. 1205 can get very, very verbose.

What were you expecting them to be writing into the error log?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

KitKaterina Ten Centuries Points: 1122 More actions · Answer 3

Hi - Thank you for your reply - I have included T3605 - I am getting output to the SQL log - but not what I have seen in the past or what I expected to see! Any other ideas?

KitKaterina Ten Centuries Points: 1122 More actions · Answer 4

Thanks for your help guys - I did finally find the cause of my problem:

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=42001&enterthread=y

Basically this is the output you get when a query use a parallel QEP.

Hopefully that info will save someone else the grief and hours this has taken me to get to the bottom of!

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 5

Very helpful information....

I always read that use about trace flag but didn't find info about how to check it's output.