how to estimate transaction per second rate ?

Hi,
2 questions.
1) Tell me if i miss something :
when i estimate the number of transaction the oracle Database and server need to compute , i have to know the following :

1. nunber of insert, update, delete, select, per application having access to the database per year.
2. calculate a) per seconde, and i'll have the number i need to estimate the server size (CPU speed, RAM, Disque speed, Network speed, clustering needed, etc)

But this give me an average of TRX per second. This does not correspond to the reality, because the system will have Peak.

2) How to i estimate a Good number of trx per second.

Example .

• I will have a System with 250 users concurrent.
• in all the tables , i will have : 1 million insert a year.
• I estimate 10% of update delete, so 100 000 a year
• I estimate that each user will select 100 time per day.: 100*250 = 25000 trx per day = 9131250 per year (365,25 day a year)

 so 1 million + 100 000 + 9131250 trx = 10 231 250 trx a year.  and this give :

    28011 trx per day (365,25 day a year)     1167 trx an hour
    19,45 a minutes
    0,32 trx a second.

    but 0,32 trx a second is a average. it will not be that way all the time.

  but the following is a little big , and not very often (let say 0,001 % of the time)

   250 user * 1 trx per seconde = 250 trx / second ,

so Question 2 : what is a Good number of trx per second.  1%, 5%, 10% , 20%,30% or more of 250 trx / second ?

thanks. Received on Thu Oct 31 2002 - 14:50:55 CST