The new Logical Process Manager in release 11.5 gives you a measure of control over the order in which Adaptive Server executes requests from connections and sessions. Two new capabilities, engine affinity and execution precedence, offer system procedures that let you tell Adaptive Server the performance trade-offs you want to make among individual connections and sessions in mixed work-load environments.
For example, you can rank a client application, login, or stored procedure as preferred with respect to others using system procedures to assign execution attributes. Adaptive Server will consider your execution assignments when it places the entity in one of three priority run queues. In addition, you can use engine affinity to make suggestions about how to partition Adaptive Server engine resources among connections and sessions.
In a multiple-application environment, establishing execution precedence can improve performance for selected applications and “on the fly” for some running Adaptive Server processes.
You establish which client applications, logins, and stored procedures receive execution precedence when you create a hierarchy among execution objects (client applications, logins, and stored procedures) using a new set of Adaptive Server system procedures (see Table 5-10). Adaptive Server uses the hierarchy as a guideline for distributing processing resources among execution objects.
For more information, see Chapter 22, “Distributing Engine Resources Between Tasks,” in the Performance and Tuning Guide.
