Re: how to estimate transaction per second rate ?

Hi Francois,

The question you need to ask yourself is to which second are you referring ?

I mean, is it the number of transactions per second at 9:00:01am, at 10:42:16am, at 8:29:29pm, on the weekend. at Christmas, during "The Bill", during the David Bowie interview on Parkinson, etc.

What you probably want to determine is which of these periods is likely to be the *busiest*. At what point(s) of time are most users likely to be doing most things and generating most *concurrent* transactions. Also what are the batch load requirements if any.

The figures you've provide are based on yearly work rates which are of minimal use, what you need to determine is the peak work rates and then by specing and tuning your environment to cope at these times, it should be able to cope at all times.

Cheers

Richard

"François Bourdages" <francois.bourdages_at_mobilair.qc.ca> wrote in message news:aadece84.0210311250.793bf726_at_posting.google.com...
> 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 :
> a) nunber of insert, update, delete, select, per application having
> access to the database per year.
> b) 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 Fri Nov 01 2002 - 00:01:11 CST