SQL Optimizer for SAP ASE 3.8 - Release Notes

Why use the SQL Scanner to Identify Problematic SQL Statements

The SQL Collector for Monitor Server offers you a way of identifying problematic SQL statements by analyzing the query plan retrieved using the sp_showplan procedure. However, Adaptive Server does not guarantee that the query plan retrieved from sp_showplan corresponds to the SQL statement. Therefore, it is recommended that you use the SQL Scanner to retrieve the query plan and identify which ones are problematic.

Note: The settings for the SQL classification for Problematic, Complex and Simple SQL statements may differ between SQL Collector for Monitor Server module and SQL Scanner module. The settings for the SQL Collector for Monitor Server module are found SQL Collecting Criteria tab in the Add Collector window. The settings for the SQL Scanner are found SQL Classification tab in the Preferences window.

Related Topics

SQL Scanner Overview

Scan Collectors

SQL Collector for Monitor Server Overview