+

Search Tips   |   Advanced Search

Database performance tuning

Database performance tuning can dramatically affect the throughput of the application. For example, if the application requires high concurrency (multiple, simultaneous interactions with backend data), an improperly tuned database can result in a bottleneck. Database access threads accumulate in a backlog when the database is not configured to accept a sufficient number of incoming requests.

Before monitoring and tuning, increase the size of the DB log files.

Because WebSphere Application Server supports the integration of many different database products, each one with unique tuning configurations, consult the database vendor documentation for comprehensive tuning information. This information center provides introductory material in the following topics:

  • Tune the application serving environment
  • Get performance data from request metrics
  • Data access tuning parameters