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

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

N/A

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

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

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.

Microsoft® .NET Framework 4.7.2

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

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

SQL Server 2008 Express

Note: SQL Server Compact edition is NOT supported.

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

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.

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.