Trace stopping and starting

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Trace stopping and starting

Postby JoonaHook » Wed Nov 09, 2011 9:56 am

Hi,
Whenever I enable trace after a while I begin to see following in logs:
SQL Trace stopped. Trace ID = '3'. Login Name = 'SqlMonitor'.
SQL Trace ID 3 was started by login "SqlMonitor".

This seems to happen once in 10 minutes and time between start and stop around 1 minute. I can even see trace being stopped by other sql user which is used in our application.

Any clue why this is happening?
JoonaHook
 
Posts: 7
Joined: Wed Nov 09, 2011 9:50 am

Postby dlkj » Wed Nov 09, 2011 3:43 pm

Trace start and stop events are logged in the SQL Server error log by default.

SQL Monitor starts and stops a new trace every 5 min. This is done so we can keep a rolling trace buffer of between 10 and 15min of data rather than creating a single very large trace file.

Cheers,
--
Daniel
dlkj
 
Posts: 151
Joined: Tue Aug 14, 2007 5:10 pm
Location: Red Gate Software, Cambridge


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests