SQL Optimizer for SAP ASE 3.8 - Installation Guide

SQL Collector for Monitor Server Tutorial

The SQL Collector for Monitor Serverallows you to capture from the ASE Monitor Server any currently executing SQL statements according to your user-defined criteria. Each SQL statement captured is categorized according to suspected levels of performance problem.

To use the collector

1. Create the Collector

   1. Click . The SQL Collector window displays, followed by the Add Collector wizard if you have not created a Collector before. If the Add Collector wizard does not display, click .

   2. Enter a Collector name and the Adaptive Server Enterprise Monitor Server name. Check that the other settings satisfy your requirements. Define a monitoring end time on the Schedule page on the Add Collector wizard.

   3. Click Finish.

2. Start the Collector

1. Click to begin capturing executing statements.

2. Details display in the SQL Collector grid as the information accumulates.

3. The monitoring process stops at the end time you define under the Schedule page in the Add Collector wizard.

3. View the results

1. To view the retrieve SQL statements, select the newly added Collector row.

2. In the SQL Text pane, click the tabs, SQL1, SQL2, and so forth to see the captured SQL statements. The SQL Information pane displays the query plan information.

3. Select one SQL statement you want to analyze for performance improvement. Click to optimize the SQL statement in the SQL Optimizer. Alternatively, you can also send the SQL statement to the Index Advisor. Click .

Related Topic

SQL Collector for Monitor Server Overview