We have a situation on our sql server side trace files causing alot of logs and the Disk is getting filled up at an alarming rate. What is happening is that an application keeps logging and logging out multiple times in a second and it generates about fourteen million records (Logins and logouts) btw 6am to 8pm (14hrs period) and this in turn generates a huge tracefile logs causing the Disk drive to fill up quickly. Any idea on what is causing the problem.
asked Apr 19, 2017 at 08:55 PM in Default
The trace files are safe to delete. .trc files generated by SQL Server in process of saving events to a physical file without using the Profiler client tool. Server-side tracing is enabled and controlled by using SQL Server system-supplied stored procedures and functions. With these system-supplied processes, you can identify what to trace, when to start and stop tracing, what traces are running, and view trace information stored in the trace file. Refer to this.
answered Apr 20, 2017 at 05:05 AM