Post reply

Transaction Statistics

  • February 13, 2003 at 1:59 pm

    #63255

    Does anyone know what the best way to record transaction statistics on a database would be? What I am trying to do is record to a database how many transactions are completed on my Prd databases on a daily basis.

    Thanks

    E...

  • February 13, 2003 at 5:40 pm

    #448949

    Use Windows Performance Monitor (in Administrative Tools). Select SQLServer:Databases as your Performance Object and Active Transactions as a counter. You will see other counters there too.

  • February 14, 2003 at 6:49 am

    #448969

    Thanks, do you know if there is a way that I can log the stats also?

    Thanks

    E...

  • February 14, 2003 at 10:24 am

    #449017

    I think you can output the Profiler results to a file. Just look at the options in the dialog box.

  • February 14, 2003 at 12:25 pm

    #449030

    Thanks.

  • February 17, 2003 at 7:19 am

    #449098

    I'm using a SQL 7.0 cluster and profiler does not work properly when attempting to run against the cluster, it causes a fail over. I do monitor the processors by connecting directly to the cluster node that is currently active but when trying to get transaction stats profiler seems to have to be connected to the cluster. Is there any possible was of maybe accessing the transaction log and reading the transactions before I back it up? That way I would be able to log them to a table. Also the log file that profiler creates gets large very fast.

    Thanks

    E...

  • February 17, 2003 at 2:33 pm

    #449148

    Of course, there is a tradeoff once you start using the Profiler: it records everything. However you can limit what you record by setting options of the trace. How to handle the cluster situation I am not sure.

    Michael

  • February 20, 2003 at 8:16 am

    #449370

    Depending on what you trying to accomplish, I don't think SQL Server Profiler is the best choice of tools. If all you are only interested in is some statistics on usage, then use Windows Performance Monitor -- specifically the counter <InstanceName>:Databases, Transaction/sec. I've used this counter for each database on a SQL Server with many databases to determine which database on a SQL Server has the highest Transaction/sec. Active will seldom be above one and I don't find that counter very useful. You can save Perfmons to a file using the Counter Logs feature. Another tool I've used is Log Explorer. Log Explorer is primarily used to recover data from log dumps, however it also has a nice Load Analysis function which produces a report of the number of transactions (both user and system) among other things. Unfortunately Log Explorer's report cannot be saved to a file.

Viewing 8 posts - 1 through 7 (of 7 total)

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