You need a disk sub system that can do at least 450 reads per second.
(multiple drives, multiple controllers) and you need to spread the load
among multiple disk drives. If the queries are efficient you need more
spindles and IO channels not necessarily a lot of CPU. Of course disk cache
is important.
Jim
"Jared Hecker" <jared_at_hwai.com> wrote in message
news:d1ppss4d1vp7k06daak9sfno9vq70ek5v3_at_4ax.com...
> Hi, all -
>
> I am configuring a Sun for a 300GB database that will, at peak load,
> have to provide approximately 450 reads/second. The writes load will
> peak at 9/sec. Reads will be of records that will max at 1K, from one
> table of four fields, all strings.
>
> I have the option of separate servers (as well as instances) to do
> this with. But we must provide this level of performance.
>
> Disk storage will be an EMC Symmetrix. I can dictate the
> configuration (so you can bet there will be multiple controllers and
> they will all have 16GB of cache(.
>
> My first thought is an E10000 (with one virtual domain) with sixteen
> processors and the maximum amount of real memory an SGA will use.
>
> If anyone has any experience with similar performance requirements I
> would appreciate hearing about it. I browsed the Sun site but
> couldn't get a good fix on the class of machine needed. Any Sun reps
> out here with access to a configurator?
>
> TIA -
>
> Regards,
> jh
> --
> Jared Hecker
> jared_at_hwai.com
> jared_at_theheckers.org
>
Received on Sat Sep 23 2000 - 15:06:05 CDT
