SQL Optimizer for SAP ASE 3.8

Item	Description
Inspector Name	User-defined unique Inspector name.
Description	Description of the Inspector defined by the user.
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.
Repeat Method	The frequency at which the inspection process captures SQL.
Last Modified	Date and time of when the Inspector was last modified.

Statistics Graphs pane

Displays charts of SQL performance according to the selected statistic in the drop-down list. Use the 2 sliders to select the SQL with the top resource consumption. The No. of Top Consumption SQL slider selects the number of SQL and the Percentage of Total Consumption slider selects the SQL statements based on the selected percentage of top resource consumption.

Statistics pane

Displays the statistics for each SQL statement retrieved from the chart selections.

The red checkmarks $image\I_RedCheckmark.gif$ in the left column indicate those SQL statements that fall in the criteria of the selected chart. If you selected AND as the mode to join multiple charts, the checkmarks are displayed in every row because every single SQL statement satisfies all the charts. If you selected OR as the mode to join multiple charts, when you click one of the charts, the red checkmarks indicate the SQL statements that correspond to the selection criteria for that chart only.

Monitor Table statistics

The system resource statistics extracted from the monitoring tables include: executions, CPU time, wait time, memory usage, physical reads, logical reads, pages modified, packets sent, packets received, CPU time per execution, wait time per execution, memory usage per execution, physical reads per execution, logical reads per execution, pages modified per execution, packets sent per execution, and packets received per execution. The login, program, host, and database names are included.

QP Metrics statistics

The system resource statistics extracted from the QP Metrics include: execution time, elapsed time, logical IO, physical IO, Execution count, and abort count.

SQL Text pane

Displays the SQL text for the statistic that is selected in the Statistics pane.

Status Bar Information

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.

Add/Modify Inspector

SQL Inspector > Add/Modify Inspector > Add/Modify Inspector

To add an Inspector

Click $image\B_AddInspector.gif$ .

To Modify an Inspector

Select the Inspector row.
Click $image\B_ModifyInspector.gif$ .

Note: If you have already executed the Inspector, modifying the Inspector criteria erases any existing information.

Documentos relacionados

The document was helpful.

Selecione a classificação

I easily found the information I needed.

Selecione a classificação

Selecione seu produto:

Para podermos atendê-lo melhor, informe o Propósito de seu chat:

Soluções recomendadas para seu problema

SQL Optimizer for SAP ASE 3.8 - User Guide

Open SQL Inspector

SQL Inspector Window

Inspector List pane

Statistics Graphs pane

Statistics pane

Monitor Table statistics

QP Metrics statistics

SQL Text pane

Status Bar Information

Add/Modify Inspector

Add/Modify Inspector