The SQL Collector for Monitor Server allows you to capture from the Adaptive Server Enterprise 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.
The SQL Collector for Monitor Server provides an easy way of viewing and analyzing any SQL statements currently running on the database server. You can specify your own criteria to use in selecting the SQL statements you want to view. Each SQL statement monitored is analyzed to see whether it is potentially problematic so that you can quickly determine which SQL statements may be causing the performance problem.
The SQL Collector window provides a work area for you to add and delete Collectors, storing information on the Collector name and description, number of SQL analyzed, start time, end time, and duration. It offers a way to view the monitored SQL statements. It displays the monitored SQL statement, corresponding query plan and related information such as server process ID (SPID), login name, capture time, and database name. You are able to copy problematic SQL statements to the SQL Optimizer for optimization.
SQL statements collected in Inspector files can be also be analyzed with the SQL Scanner module. Once you have identified potentially problematic SQL statements you can send the SQL to the SQL Optimizer, Index Advisor, the SQL Worksheet, or save them to the SQL Repository.
The SQL Collector for Monitor Server retrieves the SQL statements using the Adaptive Server Enterprise Monitor Server.