Post reply

Transaction per second

  • June 4, 2009 at 8:46 am

    #131627

    Hi,

    Anyone has any idea how to figure out what are the max transactions per second and transaction size? My server is SQL Server 2005.

    Thank you for your help.

  • June 4, 2009 at 8:50 am

    #1004690

    The performance counter SQLServer:Databases\Transactions/sec will give you the number of transactions per sec. Monitoring this counter over a suitable period of time will give you an average max/min number of tx/sec.

    How do you define the transaction size? Batch text size, rows affected, IO?

    Mark S. Rasmussen
    Blog: improve.dk
    Twitter: @improvedk
    Internals geek & author of OrcaMDF

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

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