Workload Tuning Made Easy
Tune a million-query workload today! Simply point Qure Optimizer to a copy of your production database (on a non-production server) and a trace file (representing the production workload). Let Qure Optimizer do the rest!
Summary of Recommendations
A typical workload tuning session generates hundreds of specific recommendations for improving performance, including changes to the indexing scheme, SQL rewrites, schema tweaks and more.
Recommendations in Detail
Every recommendation is accompanied by a detailed explanation and a benefit ranking.
SQL Rewrites
Recommendations for SQL rewrites include a side-by-side comparison of the original SQL and the alternative syntax, as well as a detailed explanation.
Performance Benchmarks
Every recommendation is automatically benchmarked against the copy-of-production database. Qure Optimizer replays the trace activity (ie, workload), applies the recommendations, and then re-runs the workload to measure actual performance improvement.
Applying to Production
Executable scripts are provided for applying the recommendations to production, selectively or in bulk. Thanks to the performance benchmarks, you know the benefits in advance!