Trace stopping and starting

JoonaHook

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?

dlkj

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