SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


DBCC TRACEON 3604


DBCC TRACEON 3604

Author
Message
Apurva
Apurva
SSC-Addicted
SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)

Group: General Forum Members
Points: 470 Visits: 572
Hi,
I have made a observation in our sql server 2008 log. I see "dbcc traceon 3604" which is immediately followed by "dbcc traceoff 3604". The time interval between the two commands is few milliseconds. These commands are fired alternately many times in span of few minutes which can wary from 10 to 30 mins. When I checked the full log I found this has been happening for the past 20 days and it happens at different times and on different days( doesnt happen everyday)

I am sure no user is firing this trace. What could be the reason for this trace? I tried to google and found some people complaining it for 2000 sql server , but no one had a solution or concrete answer for it.

This problem has started both on our test and production 2008 sql server around the same time. Both our servers have been running for more than 6 months. I checked our other 2005 sql servers, they dont have this problem.
I have started my own trace to figure out the problem. At the same time I would appreciate suggestions.

Thanks,
Apurva
Amit Singh
Amit Singh
Old Hand
Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)

Group: General Forum Members
Points: 321 Visits: 419
is it causing any specific errors/performance problems on your servers or you are concerned just by looking at the log file ??

3604 is used to send output back to the client instead of writing to error log. Cant say why SQL 2008 is doing it ....

is the front end app .net ??

-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! w00t - desparately trying to fish
Apurva
Apurva
SSC-Addicted
SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)

Group: General Forum Members
Points: 470 Visits: 572
Yes the front end applications are .net. You mean to say that someone from application is running it and sending the trace back to the client? If that is the case should I ask the developers?
Apurva
Apurva
SSC-Addicted
SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)

Group: General Forum Members
Points: 470 Visits: 572
Right now I dont have any performance issues. but I still need to knwo the reason this is happening.
GilaMonster
GilaMonster
SSC Guru
SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)

Group: General Forum Members
Points: 214266 Visits: 46266
Are you using any 3rd part monitoring tools?

DBCC TRACEON is usually used in conjunction with something like DBCC PAge, to return output to the client.

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


Amit Singh
Amit Singh
Old Hand
Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)

Group: General Forum Members
Points: 321 Visits: 419
yeah looks more like a monitoring tool ... but the question still remains ... is it causing any problems ???

-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! w00t - desparately trying to fish
Amit Singh
Amit Singh
Old Hand
Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)Old Hand (321 reputation)

Group: General Forum Members
Points: 321 Visits: 419
is the front end app .net ??


I asked this as i was wondering if there is some setting in driver used in connection string or something i .net thats requesting any errors back instead of writing to the error log.

-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! w00t - desparately trying to fish
Apurva
Apurva
SSC-Addicted
SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)

Group: General Forum Members
Points: 470 Visits: 572
Hi,
Around 20 days back one of the dba's in our team installed a monitoring software trial version to test. this is the same time when the commands started appearing in the sql log. I think this software may be causing it. Although it was installed on the local user PC, the software was used to connect both the test and production version of 2008. We have got the software uninstalled and hopefully the issue gets resolved.

Thanks Amit and GilaMonster
GilaMonster
GilaMonster
SSC Guru
SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)SSC Guru (214K reputation)

Group: General Forum Members
Points: 214266 Visits: 46266
Amit Singh (8/31/2009)
yeah looks more like a monitoring tool ... but the question still remains ... is it causing any problems ???


Highly unlikely. All it's doing is on one single connection getting the engine to send data to the client that would otherwise have been discarded. I've often used it on a production server

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


Apurva
Apurva
SSC-Addicted
SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)SSC-Addicted (470 reputation)

Group: General Forum Members
Points: 470 Visits: 572
Yes. It dint cause any performance problem otherwise it would have been detected long time back. My only concern was that the server was not compromised.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search