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 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.
The following pages are for selecting which database objects, abstract plan groups, or files to scan.
The summary page is for selecting to scan the jobs with the current database and 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.
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 , 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 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.
(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 or drag the item to the right-hand list field. If you want to remove an item from the right-hand list field, click 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.
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
Select the SQL Collector page.
Select a Collector and click .
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.