Performance tuning is an iterative process. Each query and each database server is different, so you must use your judgement to evaluate the output of tuning utility programs and make tuning decisions. After you make tuning adjustments, re-evaluate the effect and make further adjustments if necessary.
This section describes a general approach to evaluating a particular query or transaction. The information comes from user experience.
Database server use includes both database server concurrency issues and the load on system resources caused by operating-system processes or other processes and applications that are not associated with the database server. Although discussion of these external problems is outside the scope of this manual, monitoring the entire system use on your database server nodes can help you identify resource concurrency issues.
For information about balancing resource use and general database server tuning, see Tuning Database Server Performance.
After you analyze the context of the query or transaction and its specific requirements, you can decide how to adjust it for better performance.
The following sections contain general advice about such adjustments. For detailed suggestions, see Appendix C. Application Tuning Examples.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]