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:
|
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 |
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 |
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:
|
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. |
Before installing SQL Optimizer, review the following for virtualization support:
Requirement | Details |
---|---|
Application |
SQL Optimizer has been tested with the following:
|
Note: SQL Optimizer may work in virtualization environments other than the ones in which it was tested. |
The SQL Optimizer for SQL Server release package contains the following products:
Refer to the SQL Optimizer for SQL Server Installation Guide for installation instructions.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center