Chapter 3. Ease the Chaos with Performance Management
There are normally numerous applications running in a data center. These applications often impact the database in different ways at different times, and no application or database ever stays static; there is continuous change.
The data in the database changes as time goes by with more volumes of data being added or with continuous updates, deletions, and inserts. Application users also change in terms of more and more users and the application code itself changes with periodic application upgrades that add more functionality to the applications.
Consequently, with all these changes, the database performance is bound to deteriorate sooner or later and the DBA will always be forced to look into ...