How can we help you today? How can we help you today?

Trace stopping and starting

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
0

Comments

1 comment

Sort by
  • 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
    dlkj
    0

Add comment

Please sign in to leave a comment.