SQL Server performance monitoring and alerting
Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer
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?
- Posts: 7
- Joined: Wed Nov 09, 2011 9:50 am
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.
- 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