SQL Optimizer for SAP ASE 3.9 - User Guide

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

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

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

Add SQL Inspectors (Add Jobs Wizard)

View Add Jobs Wizard - Add SQL Inspector

(For Adaptive Server 15.0 and later)

You may want to scan the SQL Inspector to identify the SELECT, INSERT, UPDATE and DELETE SQL statements with their query plan, abstract plan and trace on information (if available). This enables you to review the query plan and helps to give a better understanding of which SQL statement is causing the performance problem within the database server.

To add a SQL Inspector

1. Click the SQL Inspector page. The left-hand list field displays a list of available Inspectors. If you have not yet created any Inspectors, this list field is blank.

2. Select an Inspector and click or drag the Inspector you want to scan over to the right-hand list field.

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.

Related Topic

Add Jobs to SQL Scanner

Add Source Code (Add Jobs Wizard)

View Add Jobs Wizard - Add Source Code Page

The SQL Scanner can scan through any source code stored as a text or a binary file to identify SQL statements.

To add sources code files

1. Select the Source Code page.

2. Select the file type and click .

   Files Types	Description
   Text/Binary	Source code saved in text or binary format.
   COBOL	COBOL source files.

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.

Related Topic

Add Jobs to SQL Scanner

Summary (Add Jobs Wizard)

View Add Jobs Wizard Summary page

Use Current DB & User

Enables you to select specific Jobs to scan using the current database and user connection

Note: When you close the Add Jobs wizard, the newly added Jobs are automatically marked in the SQL Scanner window with a black checkmark in the far left of the row.

Related Topic

Add Jobs to SQL Scanner