SQL Collector Window
View SQL Collector Window
The SQL Collector window consists of the toolbar, Job List pane, the SQL Text pane, the SQL Information pane and status bar.
Collector List
The Collector List pane in the SQL Collector window stores information on each Collector. Information includes:
| Item | Description |
|
Collector Name |
The unique Collector name defined by the user. |
|
Description |
Description of the Collector defined by the user. |
|
Status |
The current status of the Collector. This column will remain blank until the monitoring process has started. |
|
Number of SQL |
Total number of SQL statements collected |
|
Problematic SQL |
Number of Problematic SQL statements collected. |
|
Complex SQL |
Number of Complex SQL statements collected. |
|
Simple SQL |
Number of Simple SQL statements collected. |
|
SQL without Plan |
Number of SQL statements collected without a query plan. |
|
Creation Date Time |
Date and time of when the Collector was created. |
|
Start Time |
Start time of when the monitoring process starts. |
|
End Time |
End time of when the monitoring process ends. |
|
Server Name |
Monitor Server name. |
Note: The definitions of Problematic, Complex, and Simple SQL statements are provided in the SQL Collector Criteria tab of the Add Collector wizard.
SQL Text
The SQL Text pane displays the monitored SQL statements for a particular Collector. The layout of the SQL statement is unformatted and displayed according to how it is retrieved from the Adaptive Server Enterprise Monitor Server. SQL statements captured from the Monitor Server may consist of transact-SQL and stored procedures. Therefore to identify the SQL statements that you may want to optimize, you should use the SQL Scanner to identify the SELECT, UPDATE, INSERT and DELETE SQL statements that are contained with the stored procedures or transact-SQL .
SQL Information
If the query plan is retrieved for the monitored SQL statement the query plan and other details will be displayed in the SQL Information Pane
Status Bar
The status bar at the bottom of the SQL Collector window shows the following details:
| Item | Description |
|
Data Directory |
Path showing where all the data files produced during monitoring are saved. While monitoring, a progress bar displays to show the monitoring progress. |
|
Total Collectors |
Total number of Collectors. |
|
Completed |
Total number of Collectors already monitored. |
|
Remaining |
Total number of Collectors that have not been monitored. |
Note: The SQL Collector window must remain open during the monitoring process. If you have started the monitoring process, but the scheduled time has not arrived, this window must remain open for the monitoring process to start and run to completion.