Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

Add Jobs to SQL Scanner

SQL Scanner > Add Scanner Jobs > Add Jobs to SQL Scanner

The Add Jobs wizard enables you to select the database objects, abstract plan groups, Inspectors from the SQL Inspector, Collectors from the SQL Collector for Monitor Server module, SQL Inspector files, and application source or binary files that you want to scan. The Summary page enables you to control the user and database used.

To add Jobs to the SQL Scanner window

Click image\B_AddJobs.gif to display the Add Jobs wizard. The Add Jobs wizard displays automatically when the SQL Scanner window is opened if no Job exists in the SQL Scanner window.

Add Options

The following pages are for selecting which database objects, abstract plan groups, or files to scan.

Database Objects

Abstract Plan Group

SQL Collectors from the SQL Collector for Monitor Server

SQL Inspectors

Source Code

Summary Options

The summary page is for selecting to scan the jobs with the current database and user.

Use Current DB & User

When you have selected a large number of database objects, it may take a long to insert all of them into the SQL Scanner window. If you click Abort, the objects and files that have already been inserted to the SQL Scanner window remain in the window.

 

Related Topics

SQL Scanner Overview

SQL Scanner Window

Add Database Objects (Add Jobs Wizard)

SQL Scanner > Add Scanner Jobs > Add Database Objects (Add Jobs Wizard)
ClosedView Add Jobs Wizard - Add Database Objects Page

The SQL Scanner can scan all SQL statements within database objects. These include views, procedures, triggers, rules, defaults and tables. 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.

Note: You must have privilege to access the system catalog table, syscomments, therefore the select on syscomments.text configuration parameter must be turned on. Also, your access to the specific database objects depends upon the database access privileges on your logon.

By clicking each branch name, the associated list of sub-items can be expanded or collapsed. You can add a database object to a Group by highlighting the name, object type or object name, followed by clicking image\B_AddDatabaseObjects.gif, double-clicking the item, or dragging the item to the list on the right [Selected objects]. To include the objects dependencies select the corresponding checkbox from the list on the right [Selected objects].

Alternatively, you can click image\B_Ellipse.gif to open the Add Database Objects window. Select the database, user, and object type. Using the % wildcard, enter the filtering criteria. The filter is case sensitive, so you must match the upper or lowercase of the database object. Select the database objects and click OK to add the selected objects to the Add Jobs wizard. If a database object is already listed in the list on the right [Selected objects] of the Add Jobs wizard, it will not be entered again.

Note: By default, the scanning process uses the object’s database and the user who owns the object. You can change this to the current database and user on the Summary page of the Add Jobs wizard.

 

Related Topic

Add Jobs to SQL Scanner

Add Abstract Plan Groups (Add Jobs Wizard)

SQL Scanner > Add Scanner Jobs > Add Abstract Plan Groups (Add Jobs Wizard)

(For Adaptive Server 15 and later)

Use the Abstract Plan Group page of the Add Jobs wizard to scan SQL statements belonging to a particular user and abstract plan group. The list of available abstract plan group depends on whether the Show only groups with SQL checkbox is selected.

Select the abstract plan group and click image\B_AddDatabaseObjects.gif or drag the item to the right-hand list field. If you want to remove an item from the right-hand list field, click image\B_Remove.gif or drag that item out of the list field back to the left-hand field.

Select the Specify database and user checkbox and use the Use Database and Set User drop-down lists to select the database and user that corresponds with the SQL that you are scanning.

 

Related Topic

Add Jobs to SQL Scanner

Add SQL Collectors from the SQL Collector (Add Jobs Wizard)

SQL Scanner > Add Scanner Jobs > Add SQL Collectors from the SQL Collector (Add Jobs Wizard)
ClosedView Add Jobs Wizard--Add SQL Collector

You may want to scan the Collectors from the SQL Collector for Monitor Server module to identify the SELECT, INSERT, UDPATE and DELETE SQL statements with their query plan and trace on (if available). This gives you a better understanding of which SQL statement is causing the performance problem within the database server.

To add Collectors

  1. Select the SQL Collector page.

  2. Select a Collector and click image\B_AddDatabaseObjects.gif .

  3. Use the Use Database and Set User drop down lists to select the database and user that corresponds with the SQL that you are scanning.

Note: The parameter settings for Problematic, Complex, and Simple SQL statements may differ between SQL Collector for Monitor Server and SQL Scanner modules.

 

Related Topic

Add Jobs to SQL Scanner

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating