Post reply

finding the number of transactions

  • July 16, 2004 at 9:40 am

    #85889

    How do I find out how many transactions a db had during a certain time period?

    Thanks, Tracy

     

  • July 16, 2004 at 10:54 am

    #514905

    If you know in advance that you'll want that information, you could run profiler.  Otherwise, you would need a transaction log viewer, such as Lumigent's Log Explorer.

    Steve

  • July 20, 2004 at 2:07 am

    #515178

    You can use performance manager to track the number of active transactions for a particular database.

    There is a indicator in the {instancename}:databases section for active transactions this can be monitored by database or for all.

     

    Regards

    Andy Llewellyn

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

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