Uncategorised

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.