Properly choosing the workload, performance metrics, methodology, and tools for a performance-tuning project is vital to the project's ultimate success. The large number of considerations in this regard can make the preparation for performance tuning a complex undertaking in itself, but the materials provided in this article can provide some guidance.
The
companion article to this one walks through an actual case study of an optimization based on the measures established in this article.