Results 1 to 4 of 4

Thread: SQL Trace

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: SQL Trace

    Hi all I created a trace table so that I could see the users activity, I like it. Would there be any harm in letting it trace all night, or is that a bad idea.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    There is a performance hit involved, and you'd want to ensure you don't run out of disk space for the logs. Other than that, no big deal.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789
    ok cool thank you Teddy??

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Actually, this is the worst thing to do, - to send profiler trace to a table. On the contrary, the best thing to do is to send the output to a series of roll-over files. In fact, there is no need to have a trace in a table, because you can always query a trace file (or files) via ::fn_trace_xxx functionality.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •