load planning migrating ingress

[Emanuele_4]

hi everybody!

This is a difficult questione and, perhaps, there could be no answer!

I have:
One HP L3000 with 1792MB ram - 2 CPU
One HP L1000 with 1792MB ram - 2 CPU

On the first server I have 2 Ingress DBMS with 2 big databases (8GB for each one) and one little database.
On the second server I have one ingress dbms with his big database (8GB).

We are planning to migrate the second machine on the first.
We would like to put the database on the first server so that we will have:
2 DBMS with 3 big DataBases.

Actually the first machine use 18% cpu with few 80% istantaneous picks. It also use 80% (costant) of memory with no pick.
the second machine is very similar to the first.

The question is:
if I migrate the db system from the second server to the first one, will I have to upgrade the system to be able to keep everything work fine?

I think I dont' have to upgrade cpu but I'm thinking I'll have to buy more ram.

Does anybody know how much memory will be necessary managing the new configured system with 3 databases?

Thanks in advance to anybody!

Emanuele

[Huc_1]

I dont know how much more ram you would need on the HP L3000 to keep it at 80 % nor the increase in the CPU usage if you migrate the Databases..., you should find out the new ammount of ram you can put on the system and it 's price from your "HP sales contact"

But what about a scenario like this

1) install other database on HP L3000 mode while keeping the live one's running

2) export/restore databases on to HP L3000

3) start all databases the new one's only accessed by testing "user's".
start the new DB with a different name, on no critical time and with a low load (week-end?) see if the load is not to high ... then slowly load benchmark the newly restore database.


This way you have a way to measure % of load to then make a decision ?

you can also just stop the new databases if the system becomes to slow .. and perhaps wait for mem upgrade or other decision ?

Just my 0.02 Euro/cent

J-P

[Emanuele_4]

Thanks very much!

In reality it was almost what I was intended to do!

We've already migrate the database...we have populated it...we created the few necesasry users to make a test....so we're ready to make a test in which we want to run ALL the process for all the databases...we will monitor the cpu/ram load and then we could decide to buy or not to buy any hardaware.

Only one bad news: we haven't any free ram bank...so we have to change the configuartion...well...not my problem! ;-)

Thanks again

by!