Statistics	Description
CPU Time	Number of milliseconds of CPU used by the statement.
CPU Time Per Execution	Ratio between the number of milliseconds of CPU used by the statement and the number of executions.
Executions	Number of times the statement was executed during the monitoring period.
Logical Reads	Number of buffers read from cache.
Logical Reads Per Execution	Ratio between the number of buffers read from cache and the number of executions.
Mem Usage (KB)	Number of kilobytes of memory used for the execution of the statement.
Mem Usage (KB) Per Execution	Ratio between the number of kilobytes of memory used for the execution of the statement and the number of executions
Packets Received	Number of network packets received by Adaptive Server.
Packets Received Per Execution	Ratio between the number of network packets received by Adaptive Server and the number of executions.
Packets Sent	Number of network packets sent by Adaptive Server.
Packets Sent Per Execution	Ratio between the number of network packets sent by Adaptive Server and the number of executions.
Pages Modified	Number of pages modified by the statement.
Pages Modified Per Execution	Ratio between the number of pages modified by the statement and the number of executions.
Physical Reads	Number of buffers read from disk.
Physical Reads Per Execution	Ratio between the number of buffers read from disk and the number of executions.
Wait Time	Number of milliseconds the task has waited during execution of the statement.
Wait Time Per Execution	Ratio between the number of milliseconds the task has waited during execution of the statement and the number of executions.

Performance Statistics - QP Metrics

SQL Inspector > Performance Statistics - QP Metrics

Each SQL statement captured from the QP Metrics has the following performance statistics:

Statistics	Description
Execution time	How long it takes to execute the SQL statement on the CPU displayed in milliseconds.
Elapsed time	This is a total of the Execution time and the time it takes to parse, compile, and optimize the SQL statement displayed in milliseconds.
Logical IO	Total logical IO reads during the execution of the SQL statement.
Physical IO	Total physical IO reads during the execution of the SQL statement.
Execution count	Number of times the SQL statement has been executed.
Abort count	Number of times the resource governor terminated the SQL statement because a resource limit was surpassed.

The execution time, elapsed time, logical IO, and physical IO statistics each of have three values taken from the number of times the SQL statements was executed: the minimum, the maximum, and the average.

Data Directory Setting

SQL Inspector > Data Directory Setting

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 Preferences window.

Click $image\B_Preferences.gif$ .
Select the Directory Setup tab.

The default setting for this directory is:

C:\Documents and Settings\User\Application Data\Quest Software\Quest SQL Optimizer for SAP ASE\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.

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

SQL Optimizer for SAP ASE 3.8 - User Guide

SQL Inspector Privileges

Performance Statistics - Monitoring Tables

Performance Statistics - Monitor Tables

Performance Statistics - QP Metrics

Data Directory Setting