Post reply

Determining number of transactions per day against any user database.

  • September 5, 2011 at 9:14 am

    #243323

    Hi,

    Is there any mechanism of to determine the number of transactions in a day against any database?

    Regards

    Thanks.

  • September 5, 2011 at 9:22 am

    #1377075

    As far as I know, you could do an estimate by using sys.dm_os_performance_counters. use counter_name = 'transactions/sec' as your where clause along with instance_name. Please keep in mind that transactions per second is cumulative.

    -Roy

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

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