Multiprogramming level for ASA9

[former_SQLA_member326303]

Is there a way to (empirical) calculate the "best" multiprogramming level for ASA9, as a function of the values ​​of certain properties of the: - database (sa_db_properties()), - engine (sa_eng_properties()), - connection (sa_conn_info()), etc. ?

[MarkCulp · Accepted solution]

The short answer is no.

Computing the best multiprogramming level (aka MPL) is a very complicated process and the SA team - Mohammed Abouzour in particular - has spent years of research trying to do this (Note: Mohammed wrote his masters thesis on this topic). Newer versions of SA has automatic tuning of MPL as a builtin function - it encorporates "hill climbing" algorithms that watches the throughput of queries within the server and adjusts the MPL to improve the overall performance of the server. See the 12.0.1 docs for more info on auto tuning of MPL.

[former_SQLA_member326303 · Accepted solution]

Of course, I read the by Mohammed Abouzour's thesis (and thinking how to use Queueing Petri net model to this problem). Thank you.