Re: Large System

Blacker, Herb wrote: > > I'm looking for general performance characteristics (and any > tips/tricks) for anyone running a system similar to this one: > > Four (or more) 12-way 4GB S/70's (AIX 4.3) running OLTP (IDS 7.3x) with > 4000 max (1200-1500 concurrent) users. > We estimate total usage at somewhere near 600-800GB after a couple of > years running. > We'll most likely be running a single database with 1200 tables, > although it may be possible to break it up. > The rollout will be gradual, but completed by the end of '99. > We may also develop a data warehouse based on this application's data. > > Do I have enough/the right iron to do the job? > > Herb Blacker > Database Administrator > hhblack@prninc.com Wow! Nice configuration, but how do you plan to use 4 machines (and those 4GB on a 12 processor box does not sound like that much)? What are the clients? Consider throwing in a handfull of middle-layer machines running application servers and glue everything together with a good middleware (that more or less means BEA Tuxedo - see TPC numbers - but perhaps IBM TX series a.k.a. Encina is also an option). Cheers! Dragi "Bonzi" Raos 4-MATE Information Engineering Zagreb, Croatia