Qure Optimizer

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).