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
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.
”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
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.