Post reply

Number of transactions against a database

  • July 27, 2005 at 3:23 pm

    #110157

    I am trying to determine the best way to track the number of transactions (select/insert/update/delete) on a specific database by minute or hour. 

    sysperfinfo.trans/sec, perfmon or profiler?  From what I have been reading, all three would give me different results.

    Anybody have any ideas what is the most reliable?

  • August 3, 2005 at 12:00 pm

    #579276

    Profiler will give you the most complete and accurate data.  However, running Profiler can have a rather large impact on performance.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

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

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