Re: questions on scalability

From: Fortuitous Technologies <null_at_fortuitous.nul>
Date: Fri, 28 Apr 2006 18:27:05 GMT
Message-Id: <pan.2006.04.28.18.27.05.196170@fortuitous.nul>

On Fri, 14 Apr 2006 08:00:18 +0200, Magnus Warker wrote:

> Dear group,
>
> we are currently building a database cluster with Oracle 10g on two
> Primepower 250 machines. Our goal is to start with small hardware
> equipment, because of the costs, but to be able to upgrade the equipment
> and make it stronger, as the load becomes stronger.
>
> Currently we have two main questions concerning this long-term issue:
>
> 1) Measurement of load
>
> How can we define the load with respect to hardware requirements? Or: Which

> 2) Scaling up
>
> How can we ensure that the hardware equipment is always capable to meet the
> requirements?

Magnus,

Your questions are usually best answered by a performance and capacity planning study. Several firms do this type of work, such as ours. The best case scenario is to to the study well before you buy any hardware, so you don't get locked into a ill performing system. Take a look at some of the articles in
http://www.fortuitous.com/en/resources/whitepapers/

We normally try to analyze the entire system: Application, IO, CPU, memory, and network interconnects. Measurement of load is done with several performance related tools, and/or log files. We also do analysis for the distributed locking managers and caching mechanisms of Oracle RAC's Cache Fusion for sizing of clusters and grids.

  Phil Carinhas,
  Fortuitous Technologies, Inc
  http://fortuitous.com Received on Fri Apr 28 2006 - 13:27:05 CDT