question

proper12 avatar image
proper12 asked

Trace Flag T3688 not working.

Added trace flag -t3688 to the sqlserver instance startup parameter. Restarted the instance but the trace start and trace stop events are still showing in the sql error log. I have confirmed that the trace is in place. Not working on Windows server 2012 with SQL server 2012 11.0.3437. Windows server 2008 with SQL server 2008R2 10.50.4000.
trace-flags
3 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
If you run DBCC TRACESTATUS what is returned.
1 Like 1 ·
KenJ avatar image KenJ commented ·
Make sure the "T" is upper case "Important When specifying a trace flag with the -T option, use an uppercase "T" to pass the trace flag number. A lowercase 't' is accepted by SQL Server, but this sets other internal trace flags that are required only by SQL Server support engineers." http://msdn.microsoft.com/en-us/library/ms190737.aspx
0 Likes 0 ·
proper12 avatar image proper12 commented ·
I entered the Trace Flag as -T3688 but the trace start and trace stop events are still being logged in the sql error log.
0 Likes 0 ·

1 Answer

·
CirqueDeSQLeil avatar image
CirqueDeSQLeil answered
With prior versions, it required an update to the latest SP. Apply SP2 and see if that helps.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.