Tuning performance

Tuning improves performance and decreases contention and resource consumption. System administrators view:

Use this system model of Adaptive Server and its environment to identify performance problems at each layer.

Figure 1-1: Adaptive Server system model

Image showing the interaction between Adaptive Server, with its logs, data tables, shared memory, and so on, and the Open Client’s application code.

A major part of system tuning is reducing contention for system resources. As the number of users increases, contention for resources such as data and procedure caches, spinlocks on system resources, and the CPUs increases. The probability of logical lock contention also increases.