Values for parameters Mn & Ma

S

SSuhaib

Member
Iam sure this question is asked & answered many time in various Progress forums, but still didnt get any convincing answer.

Is there a formula to calculate values for -Mn, Ma, If the application is assumed an OLTP with around 50 users. Also, If the clients are connected through appserver then will the values of these parameters change or remain same irrespective of weather or not appserver is used.

Thanks in advance.
 
It all depends on your goals and objectives.

If you are connecting fat GUI clients and desire smooth performance then you probably:

1) Don't want too many clients on each server. Thus -Ma 5 or maybe lower (the ultimate would be 1).

2) Once you decide on -Ma you can set -Mn by dividing the number of users that you expect to connect client/server (So if the expected numbver of users is 50 and the desired -Ma is 5 -Mn would be 10.)

2) Want to spread connections across servers "round robin". Thus you also want -Mi 1.

Other goals and objectives may lead to different policies.

With regards to app servers -- If performance is important app servers should be running on the same host as the db and should connect self-service (no -H or -S). Thus they should not impact -Mn or -Ma.
 
You must log in or register to reply here.
Back
Top