Trace stopping and starting

JoonaHookJoonaHook Posts: 16 Bronze 2
edited November 9, 2011 9:43AM in SQL Monitor Previous Versions
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?

Comments

  • 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
Sign In or Register to comment.