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.
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.
| Feature | Resolved Issue | Defect ID |
|---|---|---|
| SQL file | The 'Open SQL text file' option now only provides the 'SQL Files' browsing option. | SOFSS-1733 |
| Licensing | The Spotlight and Foglight trial pages are not generating valid trial license keys for customers to explore the tool. | SOFSS-1732 |
| Integration | Users are unable to integrate the SQL Optimizer for SQL Server application with the trial version of Foglight for SQL Server PI edition for testing purposes. | SOFSS-1730 |
| SQL Server database servers | The SQL Optimizer for SQL Server's Connection Manager window is unable to detect any SQL Server database servers on the network. | SOFSS-1727 |
| Azure database platforms | SQL Optimizer for SQL Server now supports the following Azure SQL database features:
|
SOFSS-1722 |
| Third party library | DevExpress library version has been upgraded from 19.2.6 to 19.2.14 and from 13.2.10 to 17.2.18 for SQL Optimizer for SQL Server. | SOFSS-1692 |
| Indexing | After two hours of indexing, SQL Optimizer for SQL Server stops the process with an 'Out of Memory' error. | SOFSS-1690 |