Sean,
 
More cause for concern then .... we're currently running a hardware load 
balancer in front of 2 Remedy 7/Solaris boxes each running with (if I remember 
right) either 8 or 16 processors and 16 gig of RAM.  The backend database is 
running something like 16 processors and 32gig of RAM.  And we're currently on 
something like 70% DB utilisation.  I could be slightly out on the specs, but 
its about right.
 
Regards

Dave

-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] 
Behalf Of Garrison, Sean (Norcross)
Sent: 18 November 2008 20:22
To: [email protected]
Subject: Re: Load Balanced Remedy -> Load Balanced Oracle environments?


** 

 

 

Word of Caution on an Oracle RAC ... make sure you allocate a lot of memory to 
the db.   Here is what remedy recommends:

 

Small DB:

CPU                                       2

Memory                              4 Gig

Concurrent Users            1-400

 

sga_target                          1-2 gigs

pga_aggregate-target    1 gig

 

Medium DB:

CPU                                       4

Memory                              8 Gig

Concurrent Users            401-800

 

sga_target                          3-4 gigs

pga_aggregate-target    2 gig

 

Large DB:

CPU                                       8

Memory                              16 Gig

Concurrent Users            800 or more

 

sga_target                          6-8  gigs

pga_aggregate-target    2-4 gig

 

(page 18 on the Performance Tuning for Business Service Management Document)

 

 

One problem we ran into with RAC:  4 servers x 1 gig of memory is not equal to 
1 server X 4 gigs of memory.  The more memory you allocate to the DB the better 
your performance.  So if your remedy db is shared among other databases on the 
same server you may not be able to allocate a whole lot of memory to the db.

 

Something to keep in mind.

 

Thanks,

 

Sean

 

 

 

 

 

 


This e-mail has been scanned for viruses by the Cable & Wireless e-mail 
security system - powered by MessageLabs. For more information on a proactive 
managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ 

The information contained in this e-mail is confidential and may also be 
subject to legal privilege. It is intended only for the recipient(s) named 
above. If you are not named above as a recipient, you must not read, copy, 
disclose, forward or otherwise use the information contained in this email. If 
you have received this e-mail in error, please notify the sender (whose contact 
details are above) immediately by reply e-mail and delete the message and any 
attachments without retaining any copies.
 
Cable and Wireless plc 
Registered in England and Wales.Company Number 238525 
Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"

Reply via email to