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).
Finally, Qure Optimizer provides the DBA with comprehensive scripts for applying the recommendations to production. Recommendations may be applied by the DBA selectively or in bulk and are always accompanied by detailed explanations and undo scripts.
Qure Optimizer is part of the Qure workload management suite. The Qure suite also includes Qure Profiler, a free solution for analyzing and comparing SQL Server trace files (workloads).
Click to start the screen tour:
> 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 SQL Server tuning with 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 SQL Server performance effects of that recommendation across the entire workload, not just on an individual query.
> Recommendations: Qure Optimizer provides a wide range of detailed recommendations to improve SQL Server performance, including changes to the indexing scheme, SQL rewrites, schema tweaks and more.
> Detailed explanations and mappings: Every SQL Server tuning recommendation is accompanied by a detailed textual explanation, and all recommendations are ranked according to benefit. Recommendations are mapped to the SQL Server 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.
> SQL Server 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 SQL Server tuning recommendations are known and quantified in advance of deploying the 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 Profiler, a free companion product, supports comparison of production workloads before-and-after the deployment of the recommendations.
Supported database engines:
> SQL Server 2005/2008/2008R2/2012
> Compatibility level >= 90
> See Limitations and known issues
> Windows XP/Vista/7, Windows Server 2003/2008/2008R2 - 32 or 64 bit
> .Net Framework 3.5 SP1
> SQL Server 2005/2008/2008R2/2012 client tools
> 2 GB RAM, 5 GB free disk space, 2 GHz CPU
> Network access and security credentials with 'SysAdmin' permissions for the non-production analysis database