The Collector Properties window displays the name, description, creation date, file size and location, status, program version number, number of SQL monitored.
To view the properties of a Collector
Right-click and select Properties.
Below is a list of available functions within the SQL Collector.
Button or Menu | Function |
Collector & Right-click Menu
|
|
Collector & Right-click Menu
|
|
Monitor Menu
|
|
Right-click Menu |
|
Right-click Menu |
Ad-hoc Monitor |
Right-click Menu |
|
Right-click Menu |
|
Right-click Menu |
|
Right-click Menu |
Save |
|
|
SQL Menu |
|
SQL Menu |
|
Edit Menu
|
|
Edit Menu
|
|
Edit Menu
|
|
File Menu |
|
View Menu |
|
View Menu |
|
View Menu |
|
View Menu |
|
View Menu |
|
Report Menu |
The SQL Scanner is a unique module which extracts SQL statements embedded in applications, database objects or files without any execution of programs. It retrieves and analyzes in batch the query plans for the extracted SQL to categorize the SQL statements according to the complexity of the query plan and suspect levels of performance problems. The SQL Scanner allows you to quickly review SQL in existing code and detect potential SQL performance problems. With this approach, the SQL Scanner allows you to be proactive in the detection of performance problems. The task of extracting, reviewing and analyzing many SQL statements is simplified and automated with the SQL Scanner.
Typically database applications contain thousands of SQL statements. Without the SQL Scanner, you have to extract and review each SQL statement manually. This a very tedious and time consuming task. Once these SQL statements have been extracted, you need to manually analyze each SQL statement’s query plan to see if the query plan represents a potential performance problem. The SQL Scanner does this task for you.
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.
© ALL RIGHTS RESERVED. Nutzungsbedingungen Datenschutz Cookie Preference Center