The SQL Inspector data directory is where the data files are created while executing the Inspect function. The data directory path is set in the Options window.
Click 
Select the Directory Setup tab.
The default setting for this directory is:
C:\Users\User\Application Data\Quest Software\Quest SQL Optimizer for DB2 LUW\DATA
Changes to this directory cannot be made while the SQL Inspector is active.
Note: It is advisable not to change the data directory after you have used this function, as files created during inspecting are kept in this directory.
To open the SQL Inspector window
Click 
The SQL Inspector window consists of the Inspector List pane, Statistics pane, SQL Text pane, and status bar.
The Inspector List pane stores information on each Inspector. Information includes:
| Item | Description |
|
Inspector Name |
User-defined unique Inspector name. |
|
Status |
Current status on the Inspector. This column will remain blank until inspecting starts. |
|
No. of SQL |
Total number of SQL statements retrieved from the monitoring tables. |
|
Start At |
Date and time of when the inspecting process starts. |
|
End At |
Date and time of when the inspecting process ends. |
|
Last Modified |
Date and time of when the Inspector was last modified. |
|
Description |
Description of the Inspector defined by the user. |
Displays statistics for each SQL statement retrieved from the database:
Displays the SQL text for the statistic that is selected in the Statistics pane.
The status bar consists of the following information:
| Item | Description |
|
Data Directory |
Directory path shows where the data files produced during inspecting are saved. You can define the path of your data directory in the Preferences window. While inspecting, a progress bar will be shown to indicate the inspecting progress. |
|
Total Inspectors |
Total number of Inspectors. |
|
Completed |
Total number of Inspectors already executed. |
|
Remaining |
Total number of Inspectors that have not been executed. |
Each executed SQL statement has the following performance statistics:
| Statistics | Description |
| Executions | Number of times the statement has been executed. |
| Logical Reads | Number of data pages read from the buffer pool (logical). |
| Physical Reads | Number of data pages read from the buffer pool (physical). |
| CPU Time | CPU time used by the statement. |
| Compilations | Number of different compilations for a specific statement. |
| Worst Preparation Time | The longest number of milliseconds required to prepare a specific statement. |
| Best Preparation Time | The shortest number of milliseconds required to prepare a specific statement. |
| Rows Deleted | Number of attempted row deletions. |
| Rows Inserted | Number of attempted row insertions. |
| Rows Updated | Number of attempted row updates. |
| Rows Read | Number of rows read to return result set. |
| Rows Written | Number of rows in the table changed (inserted, deleted or updated). |
| Stmt Sorts | Number of times a set of data was sorted. |
| Sort Overflows | Number of sorts that may have required temporary disk space for storage after running out of sort heap. |
| Sort Time | Total number of milliseconds for all executed sorts. |
| Total Execute Time | Total time spent to execute a particular statement in the SQL cache. |
| Stmt Text | Text of the statement |
| Partition | Database partition from which data was retrieved for the row. |
| Snapshot Time | Date and time of the snaphot. |
