Solved

SQL Server 2005 Trace Always Running

Posted on 2011-09-29
3
238 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

688 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