Qure Optimizer The workload tuning solution that automatically optimizes millions of queries in one go.
Download

Qure Optimizer Ranking & Summary

Qure Optimizer Tags

optimizer SQL Server server optimizer workload

Qure Optimizer Description

Qure Optimizer is the leading workload tuning solution for SQL Server, delivering automatic performance optimization for SQL Server databases and applications. Since the workload to be tuned may consist of millions of queries, Qure Optimizer computes its detailed recommendations (indexing scheme, SQL rewrites, schemas changes and more) without running on the actual production database. Instead, Qure Optimizer runs against a copy-of-production, taking as input a SQL trace file of production activity (workload). After the analysis process generates the recommendations, Qure Optimizer benchmarks their actual performance improvement against the copy-of-production. Qure Optimizer does this by replaying the trace file activity, applying the recommendations, and then re-running the trace activity to measure the actual performance improvement (in Duration, IO, CPU). Main features: Automatic Workload Tuning: Multiple workload sources - Qure Optimizer supports SQL Server workloads captured in one or more trace files or trace tables, as well as workloads captured by select 3rd party monitoring tools. Large workloads supported - Qure Optimizer supports tuning of large workloads consisting of many millions of queries. Up to 10 GB of trace files or (for trace tables) 20 million events are supported. Fully automated - The workload tuning process runs completely unattended. No load on production - The working tuning process runs against a copy of the production database, restored onto a non-production server, thereby imposing zero overhead on the actual production system. Holistic balancing of performance benefits - Qure Optimizer tunes the entire workload holistically. When recommending any specific improvement (eg, “add an index”), Qure Optimizer considers the effects of that recommendation across the entire workload, not just on an individual query. Comprehensive Performance Recommendations: Recommendations - Qure Optimizer provides a wide range of detailed recommendations to improve performance, including changes to the indexing scheme, SQL rewrites, schema tweaks and more. Detailed explanations and mappings - Every recommendation is accompanied by a detailed textual explanation, and all recommendations are ranked according to benefit. Recommendations are mapped to the queries that they affect, and vice-versa. Executable scripts - Wherever possible (eg, for index recommendations and stored code rewrites) executable scripts are provided for deploying the selected recommendations to production. Index recommendations - These include recommendations to add, modify or drop specific indexes. ‘Drop’ recommendations apply only to redundant or duplicate indexes, not to unused indexes. Qure Optimizer’s advanced indexing algorithm recommends an optimal set of indexes that takes into account the entire workload, not just individual queries, so as to maximize performance benefits while avoiding over-indexing. SQL rewrite recommendations - Recommendations for SQL rewrites include a side-by-side comparison of the original SQL and the alternative syntax, as well as a detailed explanation. Both stored code and application-side code are supported. Schema and miscellaneous recommendations - Schema-level and other recommendations include potentially missing constraints, potentially unused columns, missing join conditions, SELECT * abuse, cursors not properly closed, and much more. Before-and-After Performance Benchmark: Performance benchmark - Every recommendation is automatically benchmarked against the copy-of-production database. Qure Optimizer replays the workload, applies the recommendations, and then re-runs the workload to measure actual performance improvement. Performance metrics - For each query, the performance improvement achieved is shown via a range of metrics: Duration, Physical Reads, Logical Reads, CPU and Writes. Validation of recommendations - The benchmark also validates the functional correctness of the recommendations. For example, in the case of SQL rewrites, the benchmark verifies that the result sets returned by the original SQL and the rewritten SQL are identical. Predictive knowledge - Thanks to the performance benchmarks, the benefits of the selected recommendations are known and quantified in advance of deploying the recommendations to production. Deployment of Recommendations to Production: Apply scripts - Executable scripts are provided for applying the recommendations to production, selectively or in bulk. Revert scripts - Together with every script for applying recommendations, a corresponding revert (undo) script is provided. Flexible deployment options - Recommendations may be deployed and tracked directed from Qure Optimizer, or externally via the executable scripts provided. Post-deployment comparison available - Qure Analyzer, a free companion product, supports comparison of production workloads before-and-after the deployment of the recommendations.

Qure Optimizer Related Software