Instance Tuning
- Have well-defined goals
- Allocate memory to database structures.
- Consider I/O requirements in each part of the database.
- Tune the operating system for optimal performance of the database.
Performance Tuning Methodology
The tuning steps:
- Tune from the top down.Tune:
- 1.The design
- 2.The appliation code
- 3.The instance
- Tune the area with the greatest potential benefit.Identify and tune:
- SQL using the greatest resources
- The longest waits
- The largest service times
- Stop tunning when the goal is met.