Re: 450 reads/sec on Solaris (8i) - what is needed?

First make sure that you have at least 15 spindles dedicated to addressing your read rate. Notwithstanding manufacturers' benchmarks and gigabyte cache sizes I usually factor in 30 reads per sec per spindle as am achievable figure when trying to predict system requirements from paper.

Then make sure that you definitely have the main data set spread uniformly across all 15 - it's too easy on big black boxes to find that you have the right amount of kit, but only 25% of it is being used.

How are you estimating your write rate ? Number of updates per second, number of commits per second. Including or excluding archiving ? Whilst it's reasonably safe to bet that reads probably means random database reads, writes come in many forms.

Allow at least two more spindles for redo, and another two for archived redo.

You already have the idea of the potential for bottlenecks on SCSI chains and controllers, so enough said on that one, just watch out that you don't (e.g.) mirror down a chain instead of across chains.

--

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

Jared Hecker wrote in message ...


>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

>