Trace File

I believe SQL Doctor uses server side Traces to get information (at least I think it does).
Is it possibly that the size of information it is trying to collect can cause the trace file to grow and “crash”.

I have 1 TB of data across server databases on a SQL 2012 Enterprise box. Every time I use SQL Doctor on it, I get a —

Trace ID ‘4’ was stopped because of an error. Cause: Stopping the trace because the current trace file is full and the rollover option is not specified.. Restart the trace after correcting the problem

Can the code be re-written to accommodate for growth and multiple files on this trace?

Parents
No Data
Reply
  • You’re right. During some portions of analysis we do run a trace on the workload. That error message would suggest that we don’t have trace rollover set for these traces, though, so they could fill up and only show us a narrow portion of the overall workload.

    I’ll take this in to Support for further investigation. If we make a change in the code that accommodates multiple rollover files, we can update you when a release that includes that comes out.

Children
No Data