Tuning improves performance and decreases contention and resource consumption. System administrators view:
System tuning – tuning the system as a whole. See Performance and Tuning Series: Physical Database Tuning.
Query tuning – making queries and transactions faster, and making the logical and physical database design more efficient. See Performance and Tuning Series: Query Processing and Abstract Plans.
Use this system model of Adaptive Server and its environment to identify performance problems at each layer.
Figure 1-1: Adaptive Server system model
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.