Server capacity - what parameters to be considered

[rudra132001]

Hi ,
We have a requirement to add a new progress db instance (which is a backup of an existing production db) in HP Unix server which already hosts 22 production environments .

What parameters should be considered to determine the server capacity in order to host one more db instance ..

 

[TomBascom]

You need to understand the expected workload that the new instance is going to add to your existing workload. Then you need to project that to demand for resources. Memory, CPU capacity, disk space, IO ops, network packets and so so forth.

You also need to balance the new demand vs the old and prioritize accordingly. You would, for instance, tune very differently if the new instances is a reporting db being hosted on your core production server -- you (probably) wouldn't want badly written ad hoc queries to have a negative impact on entering orders.

Once you understand how the new instance will impact things then you can start to look at how to allocate resources to it and which determine parameters (and other tuning strategies) will support the desired outcome.