Setting up Trace in SQL

From: Audrey L (robwhitz_at_yahoo.com)
Date: 11/21/03

  • Next message: Mark Vergara: "Creating Windows Authenticated User" 
    Date: Thu, 20 Nov 2003 20:30:01 -0800

    Hi,

    I have configured SQL Server to activate a trace at every
    server startup. The main objective is to audit all
    critical events on the DB.

    As the maxsize of the trace file is 5MB, I managed to
    configure it to perform a rollover whenever the threshold
    is reached.

    One thing that I would like to clarify is: - Suppose the
    trace file 'TraceA.trc' already exists in the directory.
    The DB was re-started. New records are not appended to
    the trace file at all. Is there a way to activate this?
    Or is there any workaround?

    Would appreciate advice. Thanks ...

  • Next message: Mark Vergara: "Creating Windows Authenticated User"

    Relevant Pages

    • Re: Application, session and performance.
      ... individual SQL statements between each COMMIT. ... It takes some practice learning how to read 10046 trace files. ... much of the useful data contained in the trace file is either ... a session, while recording wait events and bind variables: ...
      (comp.databases.oracle.server)
    • Re: Database Engine Tuning Advisor problem
      ... running a Tuning trace in SQL profiler and saving it to a file. ... Trace File or Trace Table Workloads that Contain the LoginName Data ... Database Engine Tuning Advisor submits Showplan requests as part of the ...
      (microsoft.public.sqlserver.tools)
    • Re: 9i Slow SQL Performance - EXPERTS apply within
      ... I did the level 12 trace and got the following results. ... Trace file: 3624.txt ... call count cpu elapsed disk query current ...
      (comp.databases.oracle.server)
    • Re: 9i Slow SQL Performance - EXPERTS apply within
      ... I did the level 12 trace and got the following results. ... Trace file: 3624.txt ... call count cpu elapsed disk query current ...
      (comp.databases.oracle.server)
    • Re: Application, session and performance.
      ... individual SQL statements between each COMMIT. ... While TKPROF can analyze 10046 trace ... much of the useful data contained in the trace file is either ... a session, while recording wait events and bind variables: ...
      (comp.databases.oracle.server)