Managing preferred access to resources

Most performance tuning techniques give you control at either the system level or at the specific query level. Adaptive Server also gives you control over the relative performance of simultaneously running tasks.

Unless you have superfluous resources, the need for control at the task level is greater in parallel execution environments because there is more competition for limited resources.

Use system procedures to assign execution attributes that indicate which tasks should be given preferred access to resources. The logical process manager uses the execution attributes when it assigns priorities to tasks and tasks to engines.

In effect, assigning execution attributes lets you suggest to Adaptive Server how to distribute engine resources between client applications, logins, and stored procedures in a mixed workload environment.

Each client application or login can initiate many Adaptive Server tasks. In a single-application environment, you can distribute resources at the login and task levels to enhance performance for chosen connections or sessions. In a multiple application environment, you can distribute resources to improve performance for selected applications and for chosen connections or sessions.

WARNING! Assign execution attributes with caution.

Arbitrary changes in the execution attributes of one client application, login, or stored procedure can adversely affect the performance of others.