SQL Server Performance

Measuring SQL transaction metrics

Discussion in 'General DBA Questions' started by Camperwell, Oct 25, 2006.

  1. Camperwell New Member

    Hi Guys,

    I'm fairly amateurish when it comes to SQL Server 2000 but I need to work out some ball-park figures on what the current metrics are for a few servers i.e. number of transactions per minute or some other gauge like that.

    I've done some research on SQL Profiler (way too much info captured?), TPC-C benchmarks, transaction log or Performance Monitor use, etc. but my eyes are starting to glaze over.

    Is there a simple way to get some metrics on current SQL2000 transaction load? Is it best to concentrate on what the transaction log has captured and analyse that somehow? There are multiple databases on the server so I kinda need a global metric for the entire server.

    Thanks in advance for any advice.

  2. joechang New Member

    there is no such thing as generally applicable transaction metrics
    a tpc-C transactions consists of 1 call to SQL with 11 updates and inserts per transaction
    1 call with 1 update, and 0.1 more complex updates
    your transaction could be completely different

    tpc-c is also completely optimized,
    chances are your application is not
    focus on understanding the characteristics of your app
    and optimizing your important queries
  3. Camperwell New Member

    Thanks Joe, bummer, these things are never easy are they?
  4. satya Moderator

    I would never take up TPC benchmarks as it tends to be different as compared to individual environment. In order to achieve the stats I would take help of PROFILER & SYSMON (PERFMON) during busy & easy periods on SQL server.
    ..the above articles should help you upto some extent.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  5. Camperwell New Member

    Excellent, thanks satya, I'll take a look at the articles and let you know if I've any issues.


Share This Page