Tchater maintenant avec le support
Tchattez avec un ingénieur du support

SQL Optimizer for SQL Server 11.0 - Release Notes

Known Issues

The following is a list of issues known to exist at the time of the SQL Optimizer release.

Feature Known Issue Defect ID
  General The SQL Optimizer for SQL Server application crashes when users click the Cancel button in the imported report. SOFSS-1846
SQL Optimizer for SQL Server is displaying an error when users are trying to open a saved session. SOFSS-1842
SQL Optimizer for SQL Server is displaying an error when users try to add scanner jobs to an existing workgroup. SOFSS-1841
SQL Optimizer for SQL Server displays the 'Memory out of bound' error when users generate the scanned job report under the Scan SQL option. SOFSS-1816
SQL Optimizer for SQL Server is displaying the Object Reference error on the 'Plan Cache Searches' window when users apply filter to the Search Name column. SOFSS-1812
SQL Optimizer for SQL Server is displaying the incorrect 'SQL statement found under this criteria' and actual 'SQL found' count. SOFSS-1809
SQL Optimizer for SQL Server displays the increased count on the 'Add Plan Cache Search' window even when searched in the same database every time. SOFSS-1808
SQL Optimizer for SQL Server displays an error instead of a validation message while scanning SQL profiler jobs. SOFSS-1777
SQL Optimizer for SQL Server is not displaying any validation messages when users assign the same tab name to multiple tabs. SOFSS-1762
General

If you uninstall the standalone version of SQL Optimizer with Toad for SQL Server and SQL Optimizer installed, you can no longer launch SQL Optimizer by sending SQL statements from Toad for SQL Server to SQL Optimizer.

ST77615

Optimize SQL

When you connect to SQL Server using Windows group, you cannot define a default schema.

Workarounds:

  1. Connect to the SQL Server with a login who has permission to create a user, and use the following script to create a user login (replace domainname\username with your NT login). USE [yourdbname] GO CREATE USER [domainman\username] FOR LOGIN [domainname\username] WITH DEFAULT_SCHEMA=[dbo] GO. After the above is created, connect to the database using Windows Authentication to use SQL Optimizer.
  2. Contact your Database Administrator to directly add your domainuser as a login.

ST84377

A SQL statement with a hidden control character in the text is classified as Invalid.

ST41386, ST98296

Optimizing SQL with DBO.Sys Objects results in a "Table does not exist" error because Sys Objects reside in the SYS schema and not the DBO schema. Since the DBO schema is only backwards compatible to SQL Server, SQL Optimizer is unable to access it.

Workaround:

Optimize SQL with Sys Objects with the SYS schema instead of the DBO schema.

ST75908

Executing SQL alternatives with an Option Clause using Query Hints for SELECT statements in CREATE VIEW causes an error because these statements are not supported by SQL Server.

Workaround:

Clear the checkbox for the SQL alternative with the Option Clause before using the Auto Optimize or Optimize function to generate alternatives without the Option Clause.

ST53842

Third Party Known Issues

The following is a list of third party issues known to exist at the time of this release.

Feature Known Issue Defect ID
Scan SQL If the SQL Server CURSOR_CLOSE_ON_COMMIT dboption parameter is not set to OFF, using the sp_helptext system stored procedure in Scan SQL may return the following error due to SQL Server BUG #: 57967 (SQLBUG_70) or BUG #: 231137 (SHILOH): Server: Msg 16917, Level 16, State 2, Line 0 Cursor is not open.

N/A

SQL Server Connection

If you are using dynamic port allocation and UDP port 1434 is disabled, SQL Optimizer may not be able to connect to SQL Server and you may receive an error message. This is a known Microsoft issue. See Microsoft Support Article ID 823938 for more information.

Workaround:Manually specify the SQL Server connection string as [Server]\[Named Instance],[Port] in SQL Optimizer.

N/A

System Requirements

Before installing SQL Optimizer for SQL Server, ensure your system meets the following minimum hardware and software requirements:

Requirement Details
Platform 600 MHz minimum, 1 GHz recommended
Memory

512 MB of RAM minimum, 1 GB recommended

Note: The memory required may vary based on the following:

  • Applications that are running on your system.
  • Size and complexity of the database.
  • Amount of database activity.
  • Number of concurrent users accessing the database
Hard Disk Space

70 MB of disk space to run SQL Optimizer

Note: This is the disk space required for a full installation, which includes 457 MB download of temporary setup files that can be removed at the completion of the installation.

Operating System

Windows 8.1 Enterprise (with Update) (32-bit or 64-bit)

Windows 10 (32-bit or 64-bit)

Windows 11 (32-bit or 64-bit)

Windows Server 2008 R2

Windows Server 2012

Windows Server 2012 R2 (with Update)

Windows Server 2016

Windows Server 2022

.NET Framework

Microsoft® .NET Framework 4.7.2

Note: The .NET Framework Client Profile is not supported.

Database Server

SQL Server® 2008, 2012, 2014, 2016, 2017, 2019, 2022

SQL Server 2008 Express

Note: SQL Server Compact edition is NOT supported.

Cloud Database Service

Microsoft SQL Azure™ Database: Azure SQL Single Database, Azure Elastic Database Pools, and Azure SQL Managed Instance

Limitation: The Find SQL and Optimize Index features are not supported

Additional Software

Microsoft Internet Explorer® 6.0 or later.

Adobe® Acrobat® Reader 7.0 or later (for viewing the Installation Guide).

SQL Server Management Objects (SMO); for more information about SMO, please visit http://msdn.microsoft.com/en-us/library/ms162189.aspx. You can also simply install Management Studio from SQL Server installation media.

Virtualization Support

Before installing SQL Optimizer, review the following for virtualization support:

Requirement Details
Application

SQL Optimizer has been tested with the following:

  • Citrix® XenApp™ 5.0 on Windows Server 2003 (Service Pack 2) using the Citrix Presentation Server Clients 4.0
  • Citrix XenApp 6.5 on Windows Server 2008 R2

Note: SQL Optimizer may work in virtualization environments other than the ones in which it was tested.

Product Licensing

Product Licensing

To activate a trial license

  1. Enter the Authorization Key included in your Trial Email into the License Key field of the Licensing dialog.
  2. Enter the Site Message included with your Authorization Key.

To activate a purchased commercial license

  1. Enter the Authorization Key included in your Purchase Email into the License Key field of the Licensing dialog.
  2. Enter the Site Message included with your Authorization Key.

Getting Started with SQL Optimizer

Getting Started with SQL Optimizer

Contents of the Release Package

The SQL Optimizer for SQL Server release package contains the following products:

  1. SQL Optimizer for SQL Server 11.0
  2. Product Documentation, including:
    • Install Guide
    • Online Help
    • Release Notes

Installation Instructions

Refer to the SQL Optimizer for SQL Server Installation Guide for installation instructions.

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation