MMDGmbH
asked on
Oracle Server Hardware
We have to invest in a new Oracle Server Hardware and i am looking for best hardware system configuration for it. Budget is not the problem.
Requirements:
current DB Size 200 GB growing by 20% per year.
no of users: 150
Oracle Version: 11 R2
Operating System: Windows 2008 Server R2 64 bit
Requirements:
current DB Size 200 GB growing by 20% per year.
no of users: 150
Oracle Version: 11 R2
Operating System: Windows 2008 Server R2 64 bit
ASKER
per hour 1000 small dialog transaction
per week 100 big transaction (which takes 5 minutes or more each)
delphi written windows application running on windows server , report generation done locally on workstations, oracle only delivers data results for executed statements.
current server Intel Xeon * 2 processors 2,8 GHz dual core, 16 GB Memory, Memory managament done by Oracle in auto mode, generally it takes between 6-7GBs for Oracle in auto mem.
total server mem usages is 8 gbs most of the time..
per week 100 big transaction (which takes 5 minutes or more each)
delphi written windows application running on windows server , report generation done locally on workstations, oracle only delivers data results for executed statements.
current server Intel Xeon * 2 processors 2,8 GHz dual core, 16 GB Memory, Memory managament done by Oracle in auto mode, generally it takes between 6-7GBs for Oracle in auto mem.
total server mem usages is 8 gbs most of the time..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
but the current server hardware is 5 years old, hdds are 3.5 years old.
OS is on Raid1 (10k RPM) and DB is on Raid 10 (SCSI 15k RPM)
it has redundent power supply etc. but this server is critical for organization so would like to change after 5 years and this would be used as some other servers for VM Ware.
OS is on Raid1 (10k RPM) and DB is on Raid 10 (SCSI 15k RPM)
it has redundent power supply etc. but this server is critical for organization so would like to change after 5 years and this would be used as some other servers for VM Ware.
Sorry i meant to say that the current server SPEC that you have is adequate.
If you wish to virtualise then of course that is a different matter, you did not mention that in the question.
If you are after a specific machine spec then you cant go wrong with running that on an R710 server.
http://configure.euro.dell.com/dellstore/config.aspx?oc=sv4r710&c=uk&l=en&s=bsd&cs=ukbsdt1&model_id=poweredge-r710
Customise and buy! Reliable and very very stable.
If you wish to virtualise then of course that is a different matter, you did not mention that in the question.
If you are after a specific machine spec then you cant go wrong with running that on an R710 server.
http://configure.euro.dell.com/dellstore/config.aspx?oc=sv4r710&c=uk&l=en&s=bsd&cs=ukbsdt1&model_id=poweredge-r710
Customise and buy! Reliable and very very stable.
ASKER
i do not want to virtualise oracle.
but once i have new server, i will use old machine to virtulise other older servers.
but once i have new server, i will use old machine to virtulise other older servers.
thats why i said it would be a different matter.........
Is this 150 users all concurrently accessing reports? Writing new records to the database? Updating LARGE amounts of data? etc...
The load on the database will dictate your needs and the number of users is only a very small part of that equation.
Can you give more detailed info on the application that this server is running?
Oracle state that you only need for example, 1gb of free RAM to install 11g but i wouldnt fancy running any apps on that!