Solved

SQL Server 2005 Trace Always Running

Posted on 2011-09-29
3
227 Views
Last Modified: 2012-05-12
SQL Server 2005. Should there always be a trace running? We have a trace running, logging to a file. It seems to have all the events in it. Is this trace running by default?
0
Comment
Question by:RDKTMC
3 Comments
 
LVL 50

Accepted Solution

by:
Lowfatspread earned 25 total points
ID: 36816553
it depends you can use trace (profiler trace) to provide an audit trail of database activity, which maybe a legal requirement in some jurisdictions (eg us sarvanes-oxley)...

however normally you would only run traces to monitor specific conditions , or to enable an analysis of on-going system performance by regularly schedling a trace for 10-15 minutes at a certain time e.g 10'30 everu wednesday for 10 minutes.

you don't mean the event log do you which is always logging.
0
 
LVL 21

Assisted Solution

by:JestersGrind
JestersGrind earned 25 total points
ID: 36816564
Are you referring to a SQL Profiler trace?  That shouldn't be running all of the time and does not run by default.  Someone has to start it.

Greg

0
 

Author Comment

by:RDKTMC
ID: 36909562
Thanks for the responses Lowfatspread and JestersGrind. The trace file is being logged to a LOG directory with a filename log_5423.trc. The log files are incrementing. The trace has been running since July 2011, probably the last time the SQL Server was restarted, or at least one of the services.

It seems to be logging all information for all events. We are in scope for SOx, but the auditors never request such a log. I'm going to speak with our DBA to get more information about it. But, your answers confirm my thought: no profiler traces run by default, so this one was configured and fired up for some reason, perhaps long-forgotten.

Thanks again for your time.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This video discusses moving either the default database or any database to a new volume.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now