Release Notes

SQL Optimizer for SQL Server® 11.0 

Release Notes

Sunday, October 29, 2023

About SQL Optimizer for SQL Server

SQL Optimizer for SQL Server® is the most comprehensive optimization solution available for SQL Server environments. SQL Optimizer helps you shorten tuning time and optimizes database performance. You can:

• Scan SQL statements embedded within database objects, SQL Server Profiler files, and application source code.
• Generate SQL statement alternatives for problematic SQL statements.
• Test SQL alternatives to find the best performing statement for your database environment.
• Generate index alternatives to improve database performance.
• Test index alternatives to find the alternative that provides the greatest performance gain.
• Optimize execution plans and deploy plan guides for SQL statements without changing original source code.
• Manage plan guides, including migrating plan guides from one database to another, importing plan guides from a file or exporting plan guides to a file as an archive, and enabling or disabling one plan guide from a batch of plan guides.
• Locate the most resource-intensive SQL in your server from the Plan Cache and from trace files and trace tables in SQL Profiler.

• Locate the most resource-intensive SQL in your server from the Extended Event files collected by SQL Server management studio.

New Features

New Features

This release of SQL Optimizer for SQL Server includes the following new features and enhancements.

Extended Events

The SQL Optimizer for SQL Server now offers an option to find SQL using Extended Events. It is important to note that SQL Server no longer supports the trace file feature for versions 2017 and above. Extended Events serve as the recommended solution for these environments. For additional information on how to find SQL using the Extended Events option, please consult the online Help.

Additional support for Cloud Database platforms

SQL Optimizer for SQL Server now supports the following Azure SQL database features:

• Optimize SQL

• Scan SQL

• Managed Plan guide

Azure SQL Single Database, Azure Elastic Database Pools, Azure SQL Managed Instance

SQL Files browsing option

The 'Open SQL text file' option now only provides the 'SQL Files' browsing option.

Back to Top

Discontinued Features

No features have been discontinued in the current release.

Resolved Issues

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release.