Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - Release Notes

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating