Post reply

How to find No. of Transaction made in a Database

  • May 9, 2008 at 3:46 am

    #123727

    I'm running SQL 2005 and SQL 2000 with a number of databases and I need to find out how many transaction are being made within one day on the server or database.

    Its is possible to find out previous transaction made on a database on a give day and find out the total amount of transactions made on the server.

    Is there a T-SQL I could run to find out these results.

  • May 9, 2008 at 4:17 am

    #812909

    you need to run / collect perfmon data to manage this - or buy a tool sauch as Idera SQL Diagnostic Manager - This is all part of trending and statistics and you'll have to do this yourself.

    I've some information on this on my web site http://www.grumpyolddba.co.uk and there's code and such on my blog.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • May 15, 2008 at 6:05 am

    #815792

    Hi there,

    Thanks for the advise, I've been able to run profmon to capiture tranaction per sec

    Cheers Rich

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

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