Red Gate forums :: View topic - Trace stopping and starting
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

Trace stopping and starting

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
JoonaHook



Joined: 09 Nov 2011
Posts: 7

PostPosted: Wed Nov 09, 2011 9:56 am    Post subject: Trace stopping and starting Reply with quote

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?
Back to top
View user's profile Send private message Send e-mail
dlkj



Joined: 14 Aug 2007
Posts: 151
Location: Red Gate Software, Cambridge

PostPosted: Wed Nov 09, 2011 3:43 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group