From tomorrow, I’m posting a series of articles on Performance Tuning overview. The focus is not specific configurations or platform specific techniques. It’s a summary of general techniques, which DBAs can apply to most systems.
In most cases the DBA weighs up the cost versus benefit of committing a change. For example RAID 10 may increase write speed for a database, but is the level of improvement worth the increase monetary cost of RAID 10?
The articles are broken down along the DBMS performance stack. DBAs develop strategies and tactics around the platform and environment.
Application
DBMS – Data System
DBMS - Access system
DBMS – Storage System
DBMS – Buffer System
OS
Hardware Tuning
Republished from http://www.dba-db2.com/.