Workload tuning is just what it sounds like: tuning all processes that comprise a database workloadin one go, balancing the effect of the tuning across all processes. The number of tuned queries orprocesses may be one thousand or one hundred million.
Until recently, this was not possible. Now it is.
The workload tuning system has already been used to optimize over 200 production databaseworkloads worldwide. It has achieved an average workload-wide performance improvement ofover 60%, including databases that had already been finely tuned using standard tuning techniquesand tools. Moreover, the precise size of the improvement on any organization’s workload can beaccurately predicted in advance of the changes being migrated to production. This is possiblebecause workload tuning provides highly accurate before-and-after benchmark measurements foreach and every process in a controlled, non-production environment.
This paper will describe how workload tuning works in detail, based on Qure Optimizer, thefirst commercially available workload tuning tool. This paper will also compare workload tuning tothe traditional query-by-query tuning method.
To learn more about workload tuning, please refer to the whitepapers page.