Consultor Eletrônico

Status: Verified

GOAL:

Does it affect performance to have all databases in the same host ?

GOAL:

Does performance decrease when having all the databases in the same host ?

FACT(s) (Environment):

All Supported Operating Systems
Progress 8.x
Progress 9.x
OpenEdge 10.x
OpenEdge Database Category: Performance

FIX:

I.- Databases performance can be reduced, generally speaking due to the following hardware limitations:

1) If there is not enough memory for all the database brokers and there is memory swapping.
2) If there is disk contention for the different database servers.
3) If CPU(s) utilization is frequently at 100%
4) If network becomes a bottleneck.
II.- Databases performance can be increased if the host provides:

A) Enough memory for the database brokers (new systems provide now larger memory capacities)
B) Disk load balance through striping or specific disk allocation per database, allowing more disk arms to work simultaneously and avoiding disk contention.
C) Good CPU utilization using -spin for multiple CPU's
D) High network bandwidth, this is now possible with the utilization of 1Gb Ethernet network cards.
It is also important to consider that processes that connect directly through shared memory have higher performance than TCP connected ones, so self-service clients, batch processes, AppServer agents, WebSpeed agents that reside in the same host perform better.
Note: With the introduction of 1Gb Ethernet or faster network cards the gap between client performance between shared memory and TCP connections is smaller. So this opens the possibility to distribute databases in different hosts if starting all databases in the same host causes performance problems.