Chat now with support
Chat mit Support

SQL Optimizer for SQL Server 11.0 - Release Notes

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.

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:
  • Optimize SQL

  • Scan SQL

  • Managed Plan guide

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


Self-Service-Tools
Knowledge Base
Benachrichtigungen und Warnmeldungen
Produkt-Support
Software-Downloads
Technische Dokumentationen
Benutzerforen
Videoanleitungen
RSS Feed
Kontakt
Unterstützung bei der Lizenzierung
Technische Support
Alle anzeigen
Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen