Solved

SQL Server 2005 Trace Always Running

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Get row count of current SQL query 8 64
Truncate vs Delete 63 108
kill process lock Sql server 9 75
Substring works but need to tweak it 14 31
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

733 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