Re: System Sizing question

You need to work out how much work
a hit will do. You also need to figure
out how you are going to link the end
users to the database.

One of the systems which I fiddle with
from time to time peaks at about 1M hits per day using a database running on a
medium sized NT box.

It can do this because:

    a hit is a very small number of logical I/Os and

    there are 8 more NTs which are running the     web servers which talk to database server     so the number of actual concurrent connections     is relatively low (about 160), and the connections     are fairly persistent.

Bottom line - the database per se should not be a problem, it's the connectivity you need to worry about.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Michael Austin wrote in message <38FF9AC1.5EF8947C_at_nc.prestige.net>...


>I suppose no one has ever had the opportunity to deal with a system of this

>magnitude.    I suppose this would be equivilent to the system that is

>currently running e-Bay.  I was thinking that it might take something the

 size


>of an E10000.  Although, there have been rumors floating about that they

 are


>going to scrap it because of some serious bugs that make it more

 susceptible


>to crashes.   The client I am dealing with insist on using Sun and I

 suppose


>they really don't care about uptime, availability and scalabilility.

>

>Michael Austin

>Oracle Rdb /Oracle 7-8-8i DBA Consultant

>

>

>Michael Austin wrote:

>

>> I take it no one wants to take a stab at this???

>>

>> Michael Austin wrote:

>>

>> > Not being familiar with the Sun platform, I am looking for input on

>> > which Sun system to get for the following application:   Database will

>> > be probably be 8i.

>> >

>> > 1-200G database  (unless it is decided to store gif images in the

>> > database) then it could push 600G.

>> > Web server that accesses database.

>> > expected 20K users  -- corporate internal system

>> > expected 15-25 hits per day per user.  Yes, folks that is 300K-500K

 hits


>> > per day

>> > Loads will be "batch" loaded at night.

>> > Retention of records will be indefinite.  (hence the 2-600G size).

>> >

>> > I know how approximately how much disk space will be required, what I

>> > need to know how is much horse-power to get.

>> >

>> > Any thoughts or ideas?

>> > Thanks,

>> >

>> > Michael Austin

>> > Oracle Rdb /Oracle 7-8-8i DBA Consultant

>