User Guide > Right Pane for Scenarios Analyzed Folder
In the Index Impact Analyzer window, when the Scenarios Analyzed Folder is selected in the left pane, the following information displays in the right pane. ... Summary button ... Provides a summary of the Estimated I/O Cost and SQL classification for the SQL statements before and after the proposed indexes were created.
Release Notes > Move or Copy Jobs to Other Group
Mark the Jobs to be moved or copied. ... Select Group | Move to Other Group or select Group | Copy to Other Group. ... Select Group where the Jobs are being moved or copied from the list. ... Click OK.
User Guide > Modify an Index Usage Analysis
You can only modify the analysis name and description. ... To modify an Analysis ... Select the Analyzer you want to modify from the left pane. ... Right-click and select Modify. ... Modify the name and/or description.
User Guide > Embedded and Dynamic SQL Statements
Generally speaking, there are two types of SQL statements found in source code. ... Embedded SQL Statements ... Embedded SQL statements refer to SQL statements that are placed within the source programs and are constructed at compilation time.
Release Notes > View and Add Charts
When you first select an Inspector in the SQL Inspector window, one chart group showing the CPU time displays in the top pane with the following: ... Statistics ... Select the statistic to display on the chart from the drop-down field.
Installation Guide > Code Finder window
The Code Finder window is divided into three sections: search criteria, where to search, and the search result. ... The search criteria displays on the top left pane. ... Review the following for additional information:
Installation Guide > Input Parameter Values
The SQL Optimizer identifies variables defined within a SQL statement and highlights them in red in the SQL Optimizer window. ... When the test run process begins, the SQL Optimizer prompts you to enter a value for the variable and to select the data type from a list through the Parameters window.
Installation Guide > Options (SQL Scanner Tab)
Specify whether the scanning algorithm will ignore any SQL statements within comments enclosed by /* */, // and -- found in the source code. ... By default, the scanning algorithm will search for any SQL statements contained in comments.
Installation Guide > Import an Abstract Plan for each User
Once the abstract plan group is exported to a table in your database, you can import it to as many users or databases as you would like. ... In the left pane of the Abstract Plan Manager, right-click and select Group | Import.
Release Notes > Generate a Report for Monitored SQL Statements
You can generate a report with the SQL statements in the SQL Collector window. ... The contents of the report depend on the components you select. ... To generate a report ... Select Report | Monitored SQL to open the Monitored SQL Report Criteria window.
Release Notes > Optimize Using Abstract Plan Only
This function is only available if you are connected to Adaptive Server 15 or later. ... The Optimize using abstract plan function optimizes the original SQL with the objective of producing an optimal abstract plan.
User Guide > Generate a Report for Monitored SQL Statements
You can generate a report with the SQL statements in the SQL Collector window. ... The contents of the report depend on the components you select. ... To generate a report ... Select Report | Monitored SQL to open the Monitored SQL Report Criteria window.
User Guide > Index Advisor Overview
The Index Advisor provides the index candidates by analyzing the structure of a SQL statement and identifying all the related tables and indexes currently used by the SQL statement. ... By looking into the search arguments and table join conditions of the SQL statement, different index candidates are generated for you to evaluate the effect new indexes may have on database performance.
User Guide > Purge Activity Log Data
Click the . ... Select the Activity Log tab. ... Under the Housekeeping section, select either Whole Log to remove all information or specify a date range to remove logs between these dates. ... Click Purge Now.
Release Notes > Lock and Unlock Chart
When the Performance Monitor is capturing statistics, the display is updated every time the statistics are gathered. ... This means that you could be reviewing some statistics and they would change while you are viewing them.
Release Notes > Object Extractor Overview
The Object Extractor allows the retrieval of the DDL text for creating the database objects. ... You can also retrieve the DDL for the object dependencies ordered by the lowest dependencies first.
User Guide > Save Search Results
You can save the search results from the Code Finder in a file. ... To save the search results ... Right-click and select Save.
User Guide > General Information
The General Information page of the Add/Modify Inspector wizard consists of the following settings: ... Item ... Enter a description for the Inspector. ... Last modified ... The date and time the Inspector was last modified.
Installation Guide > Rollback Changes to Configuration Parameters
The Migration analysis connects to the database you are migrating to and first executes the configuration parameter changes that you have selected on your database. ... Then it retrieves the query plan for each SQL statement that you have selected for your analyzer.
Installation Guide > Index Impact Analyzer Functions
Below is a list of available functions within the Index Impact Analyzer window. ... Function
Installation Guide > Create an Index Impact Analyzer
If no analysis exists in the Index Impact Analyzer then the New Analysis wizard displays automatically. ... Otherwise, click to open the New Analysis wizard. ... The New Analysis wizard the following pages to select the options for creating an analysis.
Installation Guide > Add Database Objects (Add Jobs Wizard)
The SQL Scanner can scan all SQL statements within database objects. ... Use the Database Objects page on the Add Jobs wizard. ... The database objects can be selected by their object name, object type or user name.
Installation Guide > Migration Analyzer Overview
The Migration Analyzer evaluates the effect on SQL performance when migrating to another database or Adaptive Server version. ... It enables you to analyze whether the SQL performance is going to improve or degrade by simply making a connection to the new database and viewing how query plan information will change for your selected SQL statements without physically having to execute the database applications in the new Adaptive Server version.
User Guide > Check Scanned SQL
After scanning is completed, you can review the scanned SQL statement in the SQL Scanner window. ... Is it recommended that you look at Problematic SQL, followed by Complex SQL. ... After you have reviewed a scanned SQL statement you can mark the SQL as checked.
Release Notes > Release Notes
Resolved Issues and Enhancements ... The following is a list of issues addressed and enhancements implemented in this release. ... Known Issues ... SQL Optimizer cannot terminate a database connection or an operation when the Adaptive Server transaction log is full.
New Product Association
- Self Service Tools
- Knowledge Base
- Notifications & Alerts
- Product Support
- Software Downloads
- Technical Documentation
- User Forums
- Video Tutorials
- RSS Feed
- Contact Us
- Technical Support
- View All