Factors that Affect Application Performance
The following factors can impact application server performance:
- Number of worker threads configured in the application server
- Number of configured and available database connections
- Number of users that will be concurrently uploading data
- Other applications running on the application server (CPU utilization before P6 EPPM is installed/started)
The following factors an impact database performance:
- Number of database instances on a server (dedicated versus shared)
- Disk storage system performance (I/O speed, buffer, mirroring)
- Table space layout and extent sizing
- Table data, index, and LOB distributions on table spaces
- Table and index fill factor definition
- Database block sizing
- Connection management (dedicated versus MTS)
- RAM allocations (automatic, SGA, PGA, shared pool, buffer pool)
- CBO optimizer parameter configuration setting
- Database table and index statistics gathering mechanism and frequency
- Additional database jobs
Last Published Tuesday, November 28, 2023