Choosing a Performance Optimization Method
Randolf Geist, Charles Hooper · Apress eBooks · 2010
Because there are many performance-monitoring methods, selecting the most appropriate methods that lead to a successful optimization strategy may prove to be a difficult task. This chapter begins by providing recommended starting points for performance monitoring when performance problems are reported to the DBA. Next, this chapter demonstrates the usage of several performance-monitoring methods while troubleshooting three types of performance problems, switching between the various monitoring methods as necessary. Finally, this chapter describes several common performance optimization issues, the most appropriate method to attack those issues, and several strategy guidelines that affect the course of the optimization method. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.