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?

  • Any progress on this “bug” in SQL Doctor?

  • Hi Robert,
    Remind me, you have licenses of DM as well, correct?

    I will try to trace down where this landed and update you. Do you happen to have a support case open on the issue I can reference?

  • yes, I do (one license) and no I haven’t opened a support ticket yet.

  • OK, this was opened as an enhancement request SQL Doctor as it turns out.

    “The trace in SQL doctor is designed for use over a limited period of time, so it wasn’t originally configured to roll over. It’s sound like some environments are busy enough that that may be necessary. ”

    Are you using SQL Doctor with more than one instance? If you want you can shoot me contact information on e-mail and I can talk to you about some roadmap items that might interest you.

  • Scott, I know we recently talked and discussed some “roadmap items”. Just curious, do you see SQL Doctor getting updated with this TRACE FILE fix or do I wait on the “roadmap items”.

    BTW, I have opened a case (00199164) and it is in “unsupported SQL” category and the status shows “deferred development”