Post reply

Transactions

  • December 21, 2005 at 1:13 pm

    #111855

    Is there a way for me to tell how many transactions are written to each of my db in a certain time frame?

  • December 21, 2005 at 1:23 pm

    #610951

    SQL Profiler has a SQL Transaction available in the "Available Event Classes". This tracks the BEGIN, COMMIT, ROLLBACK, SAVE statements associated with transaction.

    There is also the Transaction Log option that Tracks when transactions are written to the transaction log.

    You can then go into the Filters tab and choose a specific DB to trace the info for.

    this isn't a pretty solution and it would involve you counting them up, but i beleive it would help you find your answer.

    Regards, Jim C

  • December 21, 2005 at 2:39 pm

    #610966

    You could probably backtrack using a log reader (Apex, Lumignt, LogPI), but not sure it would be an easy answer. Might need to run reports from their products and then aggregate that info in a table or Excel.

  • December 22, 2005 at 6:07 am

    #611087

    PerfMon has a Transactions/sec count in the SQLServer : Databases object, you can log a total or by database.

    David

    If it ain't broke, don't fix it...

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

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