Red Gate forums :: View topic - Trace started / stopped messages in log
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

Trace started / stopped messages in log

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mksql



Joined: 05 Mar 2010
Posts: 6

PostPosted: Fri Mar 05, 2010 10:39 pm    Post subject: Trace started / stopped messages in log Reply with quote

It appears that SQL Response starts and stops traces when SQL profiling is enabled, generating approximately 2 log entries per minute.

Is this a known behavior of SQL Response? Is there a SQL Server flag that will suppress these messages only (without affecting other logging)?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6669

PostPosted: Sat Mar 06, 2010 11:50 pm    Post subject: Reply with quote

Hello,

SQL Response turns on some trace flags so that certain events will appear in the error log. Then SQL Response reads the trace information from the error log. That's how the detection of many events happens in SQL Response.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group