The degree to which your execution attribute assignments enhance an execution object’s performance is a function of the execution object’s characteristics and its interactions with other objects in the Adaptive Server environment. It is essential to study and understand the Adaptive Server environment in detail so that you can make decisions about how to achieve the performance goals you set.
Analysis involves these two phases:
Phase 1 – analyze the behavior of each execution object.
Phase 2 – use the results from the object analysis to make predictions about interactions between execution objects within the Adaptive Server system.
First, make a list containing every execution object that can run in the environment. Then, classify each execution object and its characteristics. Categorize the execution objects with respect to each other in terms of importance. For each, decide which one of the following applies:
It is a highly critical execution object needing enhanced response time,
It is an execution object of medium importance, or
It is a noncritical execution object that can afford slower response time.