Solved

SQL Server 2005 Trace Always Running

Posted on 2011-09-29
3
233 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article I will describe the Backup & Restore 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.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

823 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