[bbk4973]第74集 第9章 -数据库性能维护 01

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.