Workload tuning is just what it sounds like: tuning all processes that comprise a database workload in one go, balancing the effect of the tuning across all processes. The number of tuned queries or processes 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 database workloads worldwide. It has achieved an average workload-wide performance improvement of over 60%, including databases that had already been finely tuned using standard tuning techniques and tools. Moreover, the precise size of the improvement on any organization’s workload can be accurately predicted in advance of the changes being migrated to production. This is possible because workload tuning provides highly accurate before-and-after benchmark measurements for each and every process in a controlled, non-production environment.
This paper will describe how workload tuning works in detail, based on Qure Optimizer, the first commercially available workload tuning tool. This paper will also compare workload tuning to the traditional query-by-query tuning method.
To learn more about workload tuning, please refer to the whitepapers page.