Need to measure Trans Volume

• Frank-396605

  Grasshopper

  Points: 17

  More actions

  August 20, 2010 at 1:46 pm

  #97254

  Team

  I have been asked to measure :

  need to get data on transaction volumes

  -- specifically, transactions against the production database:

  [1] average daily volume

  [2] peak volume

  for couple of databases on sqlserver 2000. How can we do that?

• David Benoit

  SSC-Dedicated

  Points: 34562

  More actions

  August 20, 2010 at 1:59 pm

  #1209918

  Check out PerfMon and look at the counters for SQLServer:Databases Transactions/sec. That should allow you to collect the numbers you need.

  David

  @SQLTentmaker

  “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot