Viimeisin kampanjatiedotteemme on ilmestynyt 18.3.24, kts tarkemmat tiedot KAMPANJA-linkistä!

Softa SuperStore

19.03.2024 • • 11:57

Asiakaspalvelu
ark. 10.30 - 16
09 - 3424 370
 

          TUOTEHAKU

 TUOTERYHMÄT

 Muokkaa evästevalintoja
Näytä ostoskori
PÄÄVALIKKO
 
Luotettava Kumppani –yritys
 
Veloitukseton päivitysmuistutuspalvelu!
 
Softa SuperStore - yksi Suomen vahvimmista!

 

DBSophic Qure Optimizer

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 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:

Scripts

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

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.
System requirements:

Supported database engines:

  • SQL Server 2005/2008/2008R2/2012


Supported databases:


Installation requirements:

  • 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

Softa SuperStore
Softa SuperStore
Softa SuperStore