Summary
In this lesson, you learned that performance of an application depends on system and database resources. System resources include processing power, memory, and disk. The application can directly impact performance by how it is written to manage concurrency. Database parameters also have to be tuned properly to maximize the use of the available system resources.
When tuning the system, change one parameter at a time: Do not change more than one performance tuning parameter at a time. Even if you are sure that all the changes will be beneficial, you will have no way of evaluating how much each change contributed. You also cannot effectively judge the trade-off you have made by changing more than one parameter at a time. Every time you adjust a parameter to improve one area, you almost always affect at least one other area that you may not have considered. Changing only one at a time allows you to have a benchmark to evaluate whether the change does what you want.
|
No comments:
Post a Comment