IDS Forum

RE: CPUs dev site

Posted By: Marcus Haarmann
Date: Friday, 22 September 2006, at 9:59 a.m.

In Response To: RE: CPUs dev site (Marcus Haarmann)

Hi Tony,

You will need processors to get realistic results when stressing your
application.
You will need memory to handle the buffering/shared memory allocation of
your instance.
100 GB of data is a value which could be handled by an instance with about
4GB of memory with a relatively good performance.
If you have more than this, the better performance you might get.
I would instantiate the instance with 2-4 procs and set shared memory 1 GB,
Buffers 2 GB.
That leaves enough room for your other applications. In case you get a
problem, you could increase the values (lets say to 6 procs and more
memory). The values would differ depending on the type of operations you do
with the db (transactional things or more like reading and sorting).

Marcus

-----Original Message-----
From: Demeis, Tony [mailto:Tony.Demeis@moh.gov.on.ca]
Sent: Friday, September 22, 2006 2:52 PM
To: 'Marcus Haarmann'
Subject: RE: CPUs dev site [7525]

# of users/developers = 15
1 informix instance
Db size approx. 100gb
New functionality (n-tier env) is the main target (Performance is not the
main concern at this time) Have 16GB memory (4Lpars) The box will be running
AIX 5.3, SAS, Websphere

Thank you.
Tony

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Marcus
Haarmann
Sent: September 22, 2006 8:25 AM
To: ids@iiug.org
Subject: RE: CPUs dev site [7525]

Hi,

Informix would work on my laptop with a single CPU ...
What amount of users are you working with and what are the tasks you want to

do with it ?
What amount of data do you have to handle in your development environment ?
How many instances would you want to handle ?
It also depends on the memory amount you give the server/instance if you get

a performance problem.
I have seen running instances with 150 MB of memory per instance and some
with 6 GB of memory per instance (productive).
It always depends on the things you want to do.

E.g. we develop on a 2 Processor DB Server (Sparc CPU) on three parallel
instances with 5 developers. Performance is OK, cause we gave the instance
2GB of memory.

Marcus

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
Demeis, Tony
Sent: Friday, September 22, 2006 1:53 PM
To: ids@iiug.org
Subject: CPUs dev site [7523]

Could someone give me some advice on deciding on a minimum number of cpu's
for an informix instance in a development site.
For example, if I have a 16 cpu server with 4 LPARs, could Informix
initially operate using 4 or 6 cpus effectively assuming performance is not
the main concern.

****************************************************************************

***
Forum Note: Use "Reply" to post a response in the discussion forum.

****************************************************************************
***
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• CPUs dev site
  Demeis, Tony -- Friday, 22 September 2006, at 7:52 a.m.
  • Re: CPUs dev site
    Keith Simmons -- Friday, 22 September 2006, at 8:23 a.m.
  • RE: CPUs dev site
    Marcus Haarmann -- Friday, 22 September 2006, at 8:24 a.m.
    • RE: CPUs dev site
      Marcus Haarmann -- Friday, 22 September 2006, at 9:59 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.