Post reply

analyze select / update / delete traffic on DB

  • September 23, 2005 at 2:07 am

    #110474

    Hi,

    I'd like to know how to see the differents queries lanched on the DB and analyze the select / update / delete percentage.

    How to do that ? througth profiler ? I don"t find a column with indicates select / update / delete operation.

    Thanks

    Tom

  • September 23, 2005 at 7:03 am

    #592578

    Not sure about the percentages calculation, but in profiler you could set up 3 traces, you could specify in the filters tab in one TextData Like Select , another like Update and another like Delete and analyse the results from each of the 3 traces.

    A little crude but it may give you an idea

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

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