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.