Allotted Slices Exhausted

Number of times user tasks in each run queue exceeded the time allotted for execution. Once a user task gains access to an engine, the task is allowed to execute for a given period of time. If the task has not yielded the engine before the time is exhausted, Adaptive Server requires it to yield as soon as possible without holding critical resources. After yielding, the task is returned to the run queue.

“Allocated Slices Exhausted” helps you to determine whether there are CPU-intensive applications for which you should tune execution attributes or engine associations. If these numbers are high, it indicates that an application is CPU intensive. Application-level information can help you figure out which application to tune. Some tasks, especially those which perform large sort operations, are CPU intensive.

Use “Alloted slices exhausted” to assess new hardware requirements. Faster CPUs are typically beneficial, and the more exhausted timeslices you encounter, the more your site will benefit from upgrading to faster CPUs.