User CPU by Engine

User CPU by Engine

Time (in seconds) that each engine has been running user commands.

In a typical environment, ASE does a good job of distributing processing to engines.

However, when there are more engines than tasks, you may see some engines with a large percentage of utilization, and other engines may be idle.

If there are not more engines than tasks, and the distribution between engines is still not fairly balanced, check to see if a strategy of distributing engine resources is in place (for example, utilizing execution classes, task-to-engine affinity, etc.).  

Any change in an Adaptive Server environment in the mix of client applications, logins, and stored procedures can lead to unexpected (and negative) results in any strategy for implementing execution preference. There is a complex interdependency among the elements in this mix, and a careful study is needed to make adjustments to the allocation of resources .