Post reply

Number of Transactions

  • October 10, 2006 at 7:20 am

    #62443

    Hi,

    I am trying to determine the number of transactions per day for an individual database. I am currently using profiler to trace the TransactionLog event class to a table then counting the number of DISTINCT TransactionID's within a 24 hour period. My worry is that this method may not be accurate (or even a correct use) and there is a better way to do this task?

    Any help appreciated

    Chris

  • October 10, 2006 at 9:29 am

    #665032

    You could run a sysmon (or whatever its called these days)  server (not sql) trace and capture the av transactions per second.

     

  • October 10, 2006 at 9:32 am

    #665034

    thats the sqlserver:databases transactions/sec

    Its broken down by database.

  • October 10, 2006 at 9:38 am

    #665039

    Yeah I started using that to give me a transactions per day, but after a trawl through numerous web pages and groups discovered this wouldn't be particularly accurate.

     

    Thanks

    Chris

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

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