Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DBCC TRACEON 3604 Expand / Collapse
Author
Message
Posted Monday, August 31, 2009 12:57 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, December 5, 2013 12:31 PM
Points: 82, Visits: 567
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




Post #780161
Posted Monday, August 31, 2009 1:27 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 17, 2014 2:28 PM
Points: 110, Visits: 385
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 !! - desparately trying to fish
Post #780184
Posted Monday, August 31, 2009 1:37 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, December 5, 2013 12:31 PM
Points: 82, Visits: 567
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?
Post #780199
Posted Monday, August 31, 2009 1:38 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, December 5, 2013 12:31 PM
Points: 82, Visits: 567
Right now I dont have any performance issues. but I still need to knwo the reason this is happening.
Post #780200
Posted Monday, August 31, 2009 1:45 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
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 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 #780206
Posted Monday, August 31, 2009 1:49 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 17, 2014 2:28 PM
Points: 110, Visits: 385
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 !! - desparately trying to fish
Post #780211
Posted Monday, August 31, 2009 1:51 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 17, 2014 2:28 PM
Points: 110, Visits: 385
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 !! - desparately trying to fish
Post #780213
Posted Monday, August 31, 2009 2:06 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, December 5, 2013 12:31 PM
Points: 82, Visits: 567
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
Post #780232
Posted Monday, August 31, 2009 2:11 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
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 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 #780233
Posted Monday, August 31, 2009 2:25 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, December 5, 2013 12:31 PM
Points: 82, Visits: 567
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.
Post #780248
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse