Database performance tuning

Database performance tuning can dramatically affect the throughput of your application. For example, if your 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.

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



Subtopics
[AIX Solaris HP-UX Linux Windows] DB2 tuning parameters
[z/OS] DB2 tuning tips for z/OS
Related tasks
[AIX Solaris HP-UX Linux Windows] [z/OS] Tuning the application serving environment
[AIX Solaris HP-UX Linux Windows] [z/OS] Getting performance data from request metrics
Related reference
[AIX Solaris HP-UX Linux Windows] [z/OS] Data access tuning parameters
Reference topic    

Terms of Use | Feedback

Last updated: Oct 21, 2010 10:04:34 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=compass&product=was-nd-mp&topic=tunedatabases
File name: rdat_tunedatabases.html