?
Solved

SQL Server 2005 Trace Always Running

Posted on 2011-09-29
3
Medium Priority
?
251 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 100 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 100 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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

600 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