Tuning levels

Adaptive Server and its environment and applications can be broken into components, or tuning layers, to isolate components of the system for analysis. In many cases, you must tune two or more layers so that they work optimally together.

In some cases, removing a resource bottleneck at one layer reveals another problem area. More optimistically, resolving one problem sometimes alleviates other problems. For example, if physical I/O rates are high for queries, and you add more memory to speed response time and increase your cache hit ratio, you may ease problems with disk contention.