Tchater maintenant avec le support
Tchattez avec un ingénieur du support

SQL Optimizer for SAP ASE 3.8 - Installation Guide

Add SQL Collectors from the SQL Collector (Add Jobs Wizard)

You may want to scan the Collectors from the SQL Collector for Monitor Server module to identify the SELECT, INSERT, UDPATE and DELETE SQL statements with their query plan and trace on (if available). This gives you a better understanding of which SQL statement is causing the performance problem within the database server.

To add Collectors

  1. Select the SQL Collector page.

  2. Select a Collector and click image\B_AddDatabaseObjects.gif .

  3. Use the Use Database and Set User drop down lists to select the database and user that corresponds with the SQL that you are scanning.

Note: The parameter settings for Problematic, Complex, and Simple SQL statements may differ between SQL Collector for Monitor Server and SQL Scanner modules.

 

Related Topic

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation