Trace Flags 1204 and 1205 output changed?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Performance Tuning » Trace Flags 1204 and 1205 output changed?

Trace Flags 1204 and 1205 output changed?

Rate Topic

Display Mode

Topic Options

Author

Message

KitKaterina

Posted Thursday, July 31, 2008 11:56 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:08 AM
Points: 116, Visits: 134

Hi All

I'm a long time lurker - this is my first post, so hello and I hope you can help! :D

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?

Post #544612

Carl Federl

Posted Thursday, July 31, 2008 12:09 PM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 11:54 AM
Points: 2,224, Visits: 4,080

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

Post #544620

GilaMonster

Posted Thursday, July 31, 2008 1:17 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:49 PM
Points: 37,671, Visits: 29,925

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 2008, MVP
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

Post #544673

KitKaterina

Posted Monday, August 04, 2008 4:59 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:08 AM
Points: 116, Visits: 134

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?

Post #545993

KitKaterina

Posted Monday, August 04, 2008 11:35 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 7:08 AM
Points: 116, Visits: 134

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!

Post #546260

logicinside22

Posted Tuesday, February 14, 2012 8:22 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 12:27 PM
Points: 280, Visits: 1,027

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

Aim to inspire rather than to teach.
SQL Server DBA

Post #1251935

« Prev Topic | Next Topic »

Permissions