At the server layer, there are many shared resources, including the data and procedure caches, locks, and CPUs.
Issues at the Adaptive Server layer include:
The application types to be supported: OLTP, DSS, or a mix.
The number of users to be supported —as the number of users increases, contention for resources can shift.
Network loads.
Replication Server® or other distributed processing can be an issue when the number of users and transaction rate reach high levels.
Address these issues by:
Tuning memory (the most critical configuration parameter) and other parameters
Deciding some processing can 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 DSS and move to another Adaptive Server
