DBSophic is an innovative provider of performance management products for SQL Server based applications. While traditional SQL Server tuning tools focus on individual query optimization, DBSophic delivers automatic workload tuning. By optimizing the entire application-to-database workload, DBSophic's solutions help companies achieve unparalleled gains in SQL Server performance for their enterprise applications. The company is headquartered in Jerusalem.
Qure Optimizer is the leadingworkload
tuningsolution 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 theQure
workload management suite. The Qure suite also includesQure
Profiler, a free solution for analyzing and comparing SQL Server
trace files (workloads).
Click to start the screen tour:
SQL Server Tuning Made Easy
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 3rdparty
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.
Comprehensive SQL Server Performance Recommendations
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.