[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Server Profiler trace data files?

Posted on 2012-09-14
3
Medium Priority
?
831 Views
Last Modified: 2012-09-14
Just need an explanation really....

There are 5 .trc log files in the default location of our SQL Server 2008 production server. They're all dated for the current date (today). SQL Server Profiler logs right?

     * Why are they there?

I don't recall running SQL Profiler on the production server... if I did... it was weeks ago.

Thanks in advance!
Mike
0
Comment
Question by:rocketTendon
  • 2
3 Comments
 
LVL 3

Expert Comment

by:dave_tiller
ID: 38399583
They are default traces.  They are installed by default and keep track of generic information about the instance for troubleshooting purposes.  More information about default traces can be found at http://msdn.microsoft.com/en-us/library/ms175513.aspx.
0
 
LVL 3

Author Comment

by:rocketTendon
ID: 38400279
Is there any harm/loss of logging if I put an end to the traces?
0
 
LVL 3

Accepted Solution

by:
dave_tiller earned 2000 total points
ID: 38400393
No harm.  Just disable the default traces.  You may want to delete the physical .trc files after you do that.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
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.
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Integration Management Part 2

872 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