Re: Hardware and Network Sizes

coakleyj_at_hotmail.com wrote:

> Hi everyone.
>
> I have a query regarding bandwidth requirements and server
> sizing.
>
> 1. Using Develolper 2000 Forms in client-server mode,
> what bandwidth is typically required per user?
> Is it just dependent on the
> queries and transactions being issued?

Yes - no activity on the client side = no network traffic

> 2. If I wish to design an application
> and technical architecture so that
> system response to OLTP queries is less
> than 2 seconds,
> How would I design this?
> What would I need to consider? -
> Network latency, number of users
> and number of transactions,
> Data and indexes
> on seperate disks??
>
> What I need is a sample calculation that could be
> performed so that
> we purchase the correct server hardware and network.
>

Download a copy of the Oracle System Sizer, it allows you to model your OLTP
transactions and will give you an estimate on hardware, based on #of transactions,
database size, response time, etc.
No network, tho, but see 1)

> 3.
> When deploying the same Developer 2000 application over the web
> (i.e
> Developer Server), are the user bandwidth requirements more or less
> that that of client server?
>

Not quite - this approach loads applets and other stuff via the network, whereas
a C/S approach does not (unless you store forms on a server, of course). Bear in mind this is just an initial load, and will cause peaks in bandwith usage.
After the initial load all should be back to C/S levels.

I wouldn't worry too much about network performance, but more about server performance, and it's ability to push data into the network. Consider multiple nic's on the server, and many, many disks

>
> Any help, sample calculations, white papers, web sites
> etc
> would be greatly appreciated.
>
> Thanks for all the help
>
> Coakleyj
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

--
Met vriendelijke groet,
kind regards,

Frank van Bortel
Technical consultant Oracle
V&L Informatica BV

Work                           Home
Postbus 545                    Hunzestraat 4
7500 AM Enschede               7555 WB Hengelo
(31)53.434.1500                (31)74.242.5046