SQL Tuning for SQL Server
Version 6.3
Release Notes
June 11, 2007
SQL Tuning is the most comprehensive optimization solution available for SQL Server environments. This component offers complete SQL performance optimization with problematic SQL detection, automated SQL optimization and benchmarking capabilities. With it you can lower I/O and CPU costs with optimized SQL statements, reduce the learning curve by providing an intuitive SQL optimization environment, streamline the SQL optimization process by avoiding the trial and error method involved with manual SQL tuning. Some of its product highlights include:
New Features in SQL Tuning for SQL Server 6.3
The following is a list of issues addressed and enhancements implemented in this release of SQL Tuning for SQL Server.
|
Feature |
Resolved Issue |
Change Request |
General |
In SQL Server 2005, SQL Tuning now recognizes tables that are owned by a Schema whose name is not the same as the User name. |
CR0187607 |
| Launching SQL Tuning | When you have not selected a valid SQL statement before launching SQL Tuning for Toad, the Database drop-down list in the Tuning Lab is now correctly populated with the list of available databases. | CR0207102 |
|
You can now successfully launch SQL Tuning from Toad or Quest Central when the Server does not have a database with the same name as the User which you are currently using in Toad or Quest Central. |
CR0183732 |
|
|
Temp Tables |
The program no longer crashes when you copy some text from the SQL Text window in the Tuning Lab and paste it into the User-Defined Temp Table window. |
CR0186308 |
|
Decribe Data |
In the Table section of the Describe Data window, the Num Rows items correctly displays the number of rows in the table. |
CR0088977 |
| SQL Optimizer |
The SQL optimization process no longer causes an Access Violation when the "Transform view to derived table" option is applied to a view that was created by a user other than DBO. |
CR0206584 |
The following is a list of issues known to exist at the time of SQL Tuning for SQL Server release.
|
Feature |
Known Issue |
Change Request |
| Temp Tables
|
When the DDL for creating the temporary tables in the User-Defined Temp Table window contains a parameter, the Parameter window does not appear so you cannot enter the value for the parameter. |
CR0087382 |
| SQL Scanner | In Performance Analysis for SQL Server version 6.0, the default name of the database where the SQL Repository is created is Quest_Peformance_Repository, but you can choose a different name. In the earlier versions of Performance Analysis, the name was always Quest_Peformance_Repository. The SQL Scanner only looks for Quest_Peformance_Repository, so if another name was used for this database, the Scanner will not find the SQL Repository. | CR0213940 |
| The SCLD (single command line dynamic) scanning algorithm does not work. This scanning option is selected in the Summary page of the Add Jobs wizard. | CR0217804 | |
In the Execution Plan pane of the Scanned SQL Viewer window, when you click the Show Plan Detail button, the tables should be displayed in the left pane of the Show Plan Detail window. Sometimes the tables are missing from the display. |
CR0215985 | |
| The SQL Scanner does not open successfully when running on the Vista operating system. | CR0215986 | |
| Tuning Lab | After you have executed the Get Plan function which retrieves the execution plan for a SQL statement, the SQL classification is displayed in the Alert window. All of the information for the SQL classification is sometimes not displayed in the Alert window. Workaround: Click the Get Plan button a second time. |
CR0215557 |
| Installation | Installing SQL Tuning on a PC running the Vista operating system may fail. Workaround: Before install Quest SQL Optimizer change the following operating system setting.
|
|
| Integration with Toad | When Toad for SQL Server 3.0 is installed on your PC and you use either the "Browse Data" or Retrieve Results" feature, you will get an "Login failed for user 'username' " error message. Both of these functions are attempting to send a SQL statement to Toad which you could then execute in Toad. But the SQL statement is not displayed in the Toad editor because of the error message. | CR0211617 |
Before installing SQL Tuning for SQL Server, ensure your system meets the following minimum hardware and software requirements:
| Platform | Pentium III 500 MHZ minimum |
| Memory | 512 MB of RAM minimum Note: The memory required may vary based on the following:
|
| Hard Disk Space | 1.3 MB of disk space for installation 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 | Microsoft® Windows® 2000, 2003, or XP Professional |
| Browser | Microsoft Internet Explorer 6.0 or later |
| PDF Viewer | Adobe® Acrobat® Reader 5.0 or later (for viewing the Installation Guide) |
| Database Client | PC client connection to SQL Server via Windows authentication or DB-Library (SQL Server Authentication) |
| Database Server | Microsoft SQL Server 7, 2000, or 2005 |
This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation. This release supports any single-byte character set. Double-byte or multi-byte character sets are not supported. In this release, all product components should be configured to use the same or compatible character encoding and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America.
The SQL Tuning for SQL Server release package contains the following products:
Refer to the Installation Guide for installation instructions.
| info@quest.com | |
| Quest Software, Inc. World Headquarters 5 Polaris Way Aliso Viejo, CA 92656 USA |
|
| Web |
Refer to our Web site for regional and international office information.
Quest Support is available to customers who have a trial version of a Quest product or who have purchased a commercial version and have a valid maintenance contract.
Quest Support provides around the clock coverage with SupportLink, our web self-service. Visit SupportLink at http://support.quest.com.
From SupportLink, you can do the following:
View the Global Support Guide for a detailed explanation of support programs, online services, contact information, and policy and procedures.
The guide is available at: http://support.quest.com/pdfs/Global Support Guide.pdf.
This document contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Quest Software, Inc.
© 2007 Quest Software, Inc. ALL RIGHTS RESERVED.
Quest, Quest Software, the Quest Software logo, Aelita, AppAssure, Benchmark Factory, Big Brother, DataFactory, DeployDirector, ERDisk, Fastlane, Final, Foglight, Funnel Web, I/Watch, Imceda, InLook, IntelliProfile, Internet Weather Report, InTrust, IT Dad, JClass, Jint, JProbe, Knowledge Xpert, LeccoTech, LiteSpeed, LiveReorg, Matrix Insight, Matrix.Net, MIQ, NBSpool, NetBase, Npulse, PerformaSure, PL/Vision, Quest Central, RAPS, SharePlex, Sitraka, SmartAlarm, Speed Change Manager, Speed Coefficient, Spotlight, SQL Firewall, SQL Impact, SQL LiteSpeed, SQL Navigator, SQLab, SQLGuardian, SQLProtector, SQL Watch, Stat, Stat!, StealthCollect, Tag and Follow, Toad, T.O.A.D., Vintela, Virtual DBA, Xaffire, and XRT are trademarks and registered trademarks of Quest Software, Inc in the United States of America and other countries. Other trademarks and registered trademarks used in this guide are property of their respective owners.
If you have any questions regarding your potential use of this material, contact:
|
Quest Software World Headquarters
LEGAL Dept 5 Polaris Way Aliso Viejo, CA 92656 Email: legal@quest.com |
The information in this document is provided in connection with Quest products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Quest products. EXCEPT AS SET FORTH IN QUEST'S TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, QUEST ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL QUEST BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF QUEST HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Quest makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Quest does not make any commitment to update the information contained in this document.