troubleshooting Question

How to turn off debug / trace mode for SQL Server 2012

Avatar of jkirman
jkirmanFlag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2008Windows Server 2012SQL
14 Comments1 Solution410 ViewsLast Modified:
Greetings,

This is regarding an issue I have with an SQL 2012 server.  I had obtained assistance from Microsoft on a performance issue several months ago, and they placed the server into some sort of debug or trace mode as part of their diagnostics.  I thought they turned off the trace mode after diagnostics were completed, but as it turns out they did not.  I found this out after noting that available disk space on the SQL server's C: drive was slowly being reduced over time.  There is a debug or trace mode active that is generating daily folders containing log files for apparently every single transaction being executed on the SQL server.  Folders are named by date, so today's log files folder is under a folder called LOGS, and is named 2018-04-18.  Here is a listing of the files in that folder:

- c. 25 files named all.XX.log where XX goes from 1 thru 22.  Files vary in size from c. 15K to c. 2.5MB
- a file called all.csv which is 31K in size
- 6 files called fatal.X.log where X goes fro 0 to 6.  Files are up to 10K in size
- 15 files named Info.XX.log where XX goes from 0 thru 14.  FIles are 1K to 6K in size.
- 22 files called Trace.XX.log, where XX goes from 1 thru 22.  Files are 22K to 2.2 MB in size.
- 8 files called Warn.XX.log, where XX goes fro 0 thru 7.  Files are 1K in size.

On a typical work day, from 25 to 40 MB worth of files are generated in each daily folder.  Currently I have to manually clean these out once a month to keep the accumulation under control.

I've attached 2 files with a section of the contents of the files called all.0.log and trace.1.log

sample_of_all.0.log
sample_of_trace.1.log

Note that after attaching the 2 log files, I clicked the Embed command in the bottom right of the screen.  I hope this doesn't interfere with my having uploaded the 2 files after attaching them.  If you're unable to access the log files, please let me know and I'll re-attach.

Hopefully these files will provide an idea of what mode the SQL Server is in.  

I'm requesting advise on how to turn off this debug mode and stop the continuous generation of these log files.  Please let me know if you need any more information to assess the situation.

Many thanks,

jkirman
ASKER CERTIFIED SOLUTION
Mark Wills
Topic Advisor
Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros