SQL Optimizer for SAP ASE 3.9

Item	Description
Collector Name	The unique Collector name defined by the user.
Description	Description of the Collector defined by the user.
Status	The current status of the Collector. This column will remain blank until the monitoring process has started.
Number of SQL	Total number of SQL statements collected
Problematic SQL	Number of Problematic SQL statements collected.
Complex SQL	Number of Complex SQL statements collected.
Simple SQL	Number of Simple SQL statements collected.
SQL without Plan	Number of SQL statements collected without a query plan.
Creation Date Time	Date and time of when the Collector was created.
Start Time	Start time of when the monitoring process starts.
End Time	End time of when the monitoring process ends.
Server Name	Monitor Server name.

Note: The definitions of Problematic, Complex, and Simple SQL statements are provided in the SQL Collector Criteria tab of the Add Collector wizard.

SQL Text

The SQL Text pane displays the monitored SQL statements for a particular Collector. The layout of the SQL statement is unformatted and displayed according to how it is retrieved from the Adaptive Server Enterprise Monitor Server. SQL statements captured from the Monitor Server may consist of transact-SQL and stored procedures. Therefore to identify the SQL statements that you may want to optimize, you should use the SQL Scanner to identify the SELECT, UPDATE, INSERT and DELETE SQL statements that are contained with the stored procedures or transact-SQL .

SQL Information

If the query plan is retrieved for the monitored SQL statement the query plan and other details will be displayed in the SQL Information Pane

Status Bar

The status bar at the bottom of the SQL Collector window shows the following details:

Item	Description
Data Directory	Path showing where all the data files produced during monitoring are saved. While monitoring, a progress bar displays to show the monitoring progress.
Total Collectors	Total number of Collectors.
Completed	Total number of Collectors already monitored.
Remaining	Total number of Collectors that have not been monitored.

Note: The SQL Collector window must remain open during the monitoring process. If you have started the monitoring process, but the scheduled time has not arrived, this window must remain open for the monitoring process to start and run to completion.

Open SQL Collector for Monitor Server

SQL Collector for Monitor Server > Open SQL Collector for Monitor Server

To display the SQL Collector window

Click $image\B_SQLMonitor.gif$ .

Add or Modify a Collector

SQL Collector for Monitor Server > Add or Modify a Collector > Add or Modify a Collector

To add a Collector to the SQL Collector window

Click $image\B_AddCollector.gif$ to display the Add Collectors wizard.

To modify a Collector

Highlight the Collector row.
Click $image\B_ModifyCollector.gif$ .

Note: If you have already monitored the Collector, by modifying the Collector criteria you will erase any existing information.

Seleziona il prodotto:

Per una maggiore efficacia, compilare l'Obiettivo della chat:

Soluzioni consigliate per il problema

SQL Optimizer for SAP ASE 3.9 - User Guide

SQL Collector Window

Collector List

SQL Text

SQL Information

Status Bar

Open SQL Collector for Monitor Server

Add or Modify a Collector

Add or Modify a Collector