Chat now with support
Chat with Support

SQL Optimizer for SQL Server 10.1 - 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

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

When you launch SQL Optimizer from Windows 2000, you may get an error message, "Quest.Tuning.SQLSvr.Main has encountered a problem and needs to close."

Workaround:

Download and install MSXML 6.0 from http://www.microsoft.com/en-us/download/details.aspx?id=3988.

ST102569

Installation

If you upgrade to SQL Optimizer for SQL Server 10.0.1 from a previous version (and install versions side-by-side) and then uninstall a previous version, when you attempt to send SQL from Toad for SQL Server to SQL Optimizer, you will encounter an error. After closing the error message, the SQL may or may not be sent successfully.

Workaround:

  • Uninstall SQL Optimizer 10.0 before installing version 10.0.1.
  • Or use the Repair feature in the SQL Optimizer for SQL Server 10.0.1 .msi Installer to replace the missing files.

N/A

Installation

If you upgrade to SQL Optimizer for SQL Server 10.0.1 from a previous version and then uninstall SQL Optimizer 10.0.1, the Start menu shortcut and some installation files are not completely removed.

Workaround: After uninstalling SQL Optimizer 10.0.1, manually remove the SQL Optimizer 10.0.1 shortcut and remaining 10.0.1 installation files.

N/A

Installation

After installing SQL Optimizer for SQL Server 10.0.1, if you then install a previous version of SQL Optimizer side-by-side with 10.0.1, and then uninstall version 10.0.1, you cannot launch the previous version from the Start menu.

Workaround: Launch the previous version of SQL Optimizer using the executable in the installation directory.

N/A

Installation

When you upgrade from 7.1 to 8.0, the error window "Quest.Tuning.SQLSvr.Main" displays.

Workaround:

  1. Uninstall 7.1.
  2. Install 8.0.

ST90338

When you upgrade from 7.0 to 7.1 or from 7.1 to 8.0, Install for Everyone does not work.

ST89823

You are not provided with an option to upgrade when installing SQL Optimizer 7.1 if you have SQL Optimizer 7.0 installed with Toad for SQL Server.

Workaround:

Perform a side-by-side installation of SQL Optimizer 7.0.

ST83496

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

When using Microsoft SQL Server 2005 SP1 and optimizing certain types of SQL statements, you might encounter an "Internal Query Processor" error.

See Microsoft support article 931329 for more information.

Workaround: Upgrade to SQL Server 2005 SP2.

N/A

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® 7 (32-bit or 64-bit)

Windows 8 (32-bit or 64-bit)

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

Windows 10 (32-bit or 64-bit)

Windows Server 2008 R2

Windows Server 2012

Windows Server 2012 R2 (with Update)

Windows Server 2016

.NET Framework

Microsoft® .NET Framework 4.0

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

Database Server

SQL Server® 2005, 2008, 2012, 2014, 2016, 2017

  • SQL Optimizer has been tested against SQL Server 2017 running on Windows or Linux.

SQL Server 2005 Express

SQL Server 2008 Express

Note: SQL Server Compact edition is NOT supported.

Cloud Database Service Microsoft SQL Azure™ Database
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

Contents of the Release Package

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

  1. SQL Optimizer for SQL Server 10.1
  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.


Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating