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

EMC takes care of redundancy and eliminates single points of failures at all levels.

'Protected storage' is the term.

Writes are small. Reads are large. Tune the application or you'll die here e.g. index correctly.

EMC cache is expensive. You won't be able to afford a lot.

Don't oversize the SGA - it should be 60% of total RAM.

Allow 2-3Mb per user session (assuming a SORT AREA SIZE of 1Mb or so).

Use an OS logical volume manager to abstract the Symmetrix Logical Volumes - you'll love the flexibility this will give you.

The common mistake is to try and size the symmetrix logical volumes (LUNs) but these should be considered merely as 'building blocks' of stoage for your logical volume manager to use when you are creating your *OS* logical volumes.

Make sure the EMC consultants review your plans - they doubtless will come up with improvements.

Which version of Oracle are you planning to use and will it be Enterprise Edition (should be) or Standard?

Also - are you going to use Parallel Server?

Food for thought.

David Pomphrey, OCP MCP B.Tech

• 0.6 Terabytes and I feel fine ---

  ---

Jared Hecker wrote:
>
> 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:23:49 CDT