title: how to calculate database transaction count per second and database growth
body: <p>I need to learn about calculating database load of a project . Lets assume that the events below are firing when an insert is completed.</p>
  
  <ol>
  <li>Insert a new record to table1 </li>
  <li>Get the uniqueid from inserted and insert the uniqueid to another table , with some other parameters</li>
  <li>table1 is a cumulative dataware , so 
  <code>select count(1) from table1 where anotherColumn = xxyyx</code> command is fired</li>
  <li>After count result received , update another table with this count</li>
  </ol>
  
  <p>I need to calculate how many transactions are opened and what is the cpu load of database when 100 or 1000 times this scenario is fired at the same time.</p>
  
  <p>Thanks...</p>