RE: server sizing [NT: need XEON?]

From: Eric D. Pierce <PierceED_at_csus.edu>
Date: Tue, 17 Apr 2001 16:22:30 -0700
Message-ID: <F001.002EB6E5.20010417155548@fatcity.com>

Lerone,

I stumbled across a skimpy, but perhaps interesting, "Capacity Planning" chapter in:

_Oracle Forms Server Release 6i: Deploying Forms Applications to the Web with Oracle Forms Server for Windows and Unix_

http://docs.oracle.com/a84664/SHIPHOME/DOC/product_0/index.htm -
http://docs.oracle.com/a84664/SHIPHOME/DOC/product_0/a73071.pdf

(starting at http://docs.oracle.com, click: database | tools| MS Win NT | Oracle(r) Tools Version CD Pack v8...)

They contrast scability for small and medium (no large) dbs on Intel vs. Sun (2 processors only!), and talk of things on the order of 500 NT users for "small" dbs, 300 NT users (max) for "medium" dbs.

Of course since the document is about a year old, they are talking about a PII 2 processor Intel 200Mhz server as "small" and a PII 2 processor 400Mhz server as "medium"!

Also, in the Oracle8i (Enterprise?) Install docs, they discuss support for RAM>4GB on NT (and Win2000) but this requires XEON, and special drivers. Unles I'm confusing that toic with some of the other mass of Oracle/NT stuff I've read lately, you can only run one Oracle instance with the oversized (>4gb) NT memory configuration on XEON. Sorry I'm not well enough versed in the nuances of RAID for large servers to say much (except get about the most high-end controllers you can afford). If you can get ahold of him, or can wait until he isn't so busy, Paul Drake of this list is the resident RAID/hardware expert.

Other resources (sorry if you've already seen them):

-
http://www.geocities.com/tbcox23/generic_oracle_nt_config.pdf

-
http://www.geocities.com/tbcox23

-
http://www.ultratech-llc.com/Personal/Files/

-
http://www.ultratech-llc.com/Personal/Files/?File=RAID.TXT

-
http://www.ultratech-llc.com/Personal/Files/?File=ServerSpecs.TXT

-
http://www.ultratech-llc.com/KB/?File=Hardware.TXT

regards,
ep

On 17 Apr 2001, at 12:11, Streeter, Lerone A LBX wrote:

Date sent:              Tue, 17 Apr 2001 12:11:22 -0800
To:                     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

...

> why NT?  familiarity and comfort.  we've asked and everyone doted on
> oracle's ability to run on NT just as well as *nix and being that we have 0
> *nix boxes mgmt of course wanted NT.  we looked for support in having oracle
> on *nix but found none and accepted the offering.

...

>>...right now we have about 100 users and a 20G DB which *will*

>> increase to probably 300 users and 40G to 50G DB; on average we're
>> looking at about thirty thousand transactions over an 11 hour
>> period; again that'll probably increase to 70,000 to 80,000
>> transactions over an 11 hour period. reads/writes/queries/indexes,
>> their size and speed, and other such processing metrics, were
>> never a concern.

...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: PierceED_at_csus.edu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Apr 17 2001 - 18:22:30 CDT