DBSophic

Qure Optimizer v2.7 offers the following advantages:

  • Support for using a full SQL Server database as the Qure Optimizer's repository. Previous versions used a SQL Server Compact Edition file which placed significant limitations on the optimization. Using a SQL Server database repository, Qure Optimizer will allow you to:
    • Optimize up to 10 databases in a single analysis.
    • Optimize multi-terabyte databases.
    • Optimize databases that contain hundreds of thousands of objects.
    • Optimize workloads up to 20 Million events.
  • Full SQL Server 2016 support.
    • Allows Optimizations of SQL Server 2016 workloads.
    • Allows using SQL Server 2016 databases as the workload analysis repository.
  • Improved performance of optimization.
  • Significantly reduced memory and CPU consumption.
  • Many new optimizations, including:
    • Table variable rewrites.
    • Temporary table indexing.
    • Optimizing non-expandable scalar UDF.
    • INSERT / UPDATE / DELETE optimizations.
    • Improved indexing algorithm that better optimizer complex T-SQL constructs.
  • IAssociation of indexes used via UDFs that do not appear in the execution plan.
  • ISupport for optimizing workloads directly from "SQL Sentry Performance Manager" repository.
  • INew representation of benchmarked parameter set selection that greatly enhances performance and usability.