troubleshooting Question
How to turn off debug / trace mode for SQL Server 2012
asked on
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
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
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.
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.