Extremely high tracefile log from app

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.

more ▼

asked Apr 19, 2017 at 08:55 PM in Default

avatar image

1 1 5

Have you checked to see what the file size limit might be? As well as how many files the trace will allow? You can adjust those to help prevent the drive from filling up.

Apr 20, 2017 at 01:50 AM JohnM
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Apr 20, 2017 at 05:05 AM

avatar image

421 3 7

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 19, 2017 at 08:55 PM

Seen: 47 times

Last Updated: Apr 20, 2017 at 05:05 AM

Copyright 2018 Redgate Software. Privacy Policy