Post reply

Tracing db activity on all objects

  • June 14, 2004 at 1:22 pm

    #108696

    I'm trying to run a trace that will produce all objects that are accessed via insert, select, delete or update.  I see the objects:opened event class but that doesn't seem to work.  We're trying to see which tables are accessed the most during our nightly batch process.  Any help would be appreciated.

    Thanks


    Darren

  • June 17, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • June 17, 2004 at 9:13 am

    #510871

    You can always try running a standard profiler trace overnight and saving the results to a table.  You can then report on that table the number of times each objects come up in relation to an SELECT/INSERT/UPDATE/DELETE statement.

    JM

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply