At the server layer, there are many shared resources, including the data and procedure caches, locks, and CPUs.
Issues at the Adaptive Server layer are as follows:
The application types to be supported: OLTP, DSS, or a mix.
The number of users to be supported can affect tuning decisions—as the number of users increases, contention for resources can shift.
Replication Server® or other distributed processing can be an issue when the number of users and transaction rate reach high levels.
Options to address these issues include:
Tuning memory (the most critical configuration parameter) and other parameters.
Deciding on client vs. server processing—can some processing take place at the client side?
Configuring cache sizes and I/O sizes.
Adding multiple CPUs.
Scheduling batch jobs and reporting for off-hours.
Reconfiguring certain parameters for shifting workload patterns.
Determining whether it is possible to move DSS to another Adaptive Server.