RE: Capacity Planning

Mike

You have not specified how much memory is on the machine, neither have you specified which application you will be running against the box. also, are you going to be using an intelligent RAID controller device (EMC, Shark, similar) with this ? Are you running this across a LAN / WAN ? Are all 300 users distributed across a few physical sites ?

for OLTP, I think your system is way overkill, but always better to have more rather than less. for a DW situation, you may be underpowered, though not many sites have 300 marketing type / OLAP users connected, so I am going to assume your are running an OLTP type DB, in which case, you should be happy with the performance and scalability. HTH.

Regards:
Ferenc Mantfeld
Senior Performance Engineer
Siebel Performance Engineering
Melbourne, 3000, VIC, Australia
Please note 17 hour time difference between Melbourne and CA Only Robinson Crusoe had all his work done by Friday

-----Original Message-----
Sent: Friday, 14 June 2002 6:23 AM
To: Multiple recipients of list ORACLE-L

Good morning,

I am trying determine whether a proposed 8-way Intel (Unisys ES7000) system running Windows 2000 will support our anticipated work load.

I know this question has a LOT of variables but I don't even have a feel for some of the numbers.

Two things:

One - just to get an idea of the scale of things, is 300 concurrent users a
'lot' on such a system?

Like I said, I KNOW there are many other variables - specifically, what the users are doing at the time, tunning, ... but I am wondering (assuming well written queries, apps, database design, ...) if this number is in the range of

'THIS SYSTEM IS OVERKILL'
'PROBABLY OK'
'HMM BETTER LOOK OUT'
'YOU ARE INSANE AND WILL BE JOB HUNTING SOON'
Does anyone have a similar system running with say ... 1000 concurrent users? 100? 5000???

Two - Can anyone point me to resources (other than the vendors) that might help. I don't know why I have such distrust for someone who wants my money.

Thanks,

Mike

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bond Mike A Contr OC-ALC/TILC
  INET: Mike.Bond_at_tinker.af.mil

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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ferenc Mantfeld
  INET: fmantfeld_at_siebel.com

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).