Trace started / stopped messages in log

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

Trace started / stopped messages in log

Postby mksql » Fri Mar 05, 2010 10:39 pm

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)?
Posts: 6
Joined: Fri Mar 05, 2010 10:35 pm

Postby Brian Donahue » Sat Mar 06, 2010 11:50 pm


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.
Brian Donahue
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests