立即与支持人员聊天
与支持团队交流

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

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级