Scan SQL
SQL Scanner extracts SQL statements embedded in database objects, captured from SQL Profiler, stored in application source code and binary files, or saved in a Foglight Performance Analysis SQL Repository. Use the Add Scanner Jobs wizard to create scan jobs using statements from any of these sources.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To create a scan job
- Select the Scan SQL tab in the main window.
-
Click Add Scanner Job from the Welcome pane.
Tip: You can navigate directly to the embedded SQL statement for a particular format by clicking one of the links from the Welcome pane.
-
Select a connection to use for the scan job. Review the following for additional information:
Select Connection Description Connection
Click
to select a previously created connection.
Tip: Click
to open the Connection Manager to create a new connection.
Select Database and User Description Database
Click Set User
Click -
Select the page for the type of statement you want to add to the scan job. Review the following for additional information:
Database Objects Page Description Database Objects
Select a database object and click
to add the object to scan.
Tip: Click
SQL Profiler Page Description Available trace files/table
Click Database
Click Set User
Click Source Code Page Description Source code type
Select Text/Binary files or COBOL programming source code to indicate the source code type. Add by file
Click and browse to the files you want to scan.
Add by directory
Click
Note: Select the Include Sub-directory checkbox to scan sub-directories.
Connection for scanning
Select the database and user name settings. Foglight Performance Analysis Page Description Connection
Click
Tip: Click
Database
Click Connection for scanning
Select the database and user name settings.
Note: Use this connection when the SQL statements you want to scan and the Foglight Performance Analysis repository are not located in the same database.
Note: SQL Scanner helps you manage scan jobs by organizing them into groups. Use the Group Information page to create a new group or to add the current scan job to an existing group.
-
Select the Group for the scan job you created in the Scanner node of the Task pane once SQL Scanner finishes scanning.
-
Select the scan job in the Group node.
-
Identify problematic SQL statements in the SQL List pane. See View SQL Classification for more information.
-
Select SQL statements to send to SQL Optimizer for optimization. See Send to Optimize SQL for more information.