SQL Optimizer for SAP ASE 3.9.1

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.

SQL Collector Functions

SQL Collector for Monitor Server > SQL Collector Functions

Below is a list of available functions within the SQL Collector.

Button or Menu	Function
Collector & Right-click Menu $image\B_AddCollector.gif$	Add Collector
Collector & Right-click Menu $image\B_ModifyCollector.gif$	Modify Collector
Monitor Menu $image\B_Monitor.gif$ $image\B_AbortMonitor.gif$	Monitor/Abort Monitor
Right-click Menu	Add/Remove Bookmark
Right-click Menu	Ad-hoc Monitor
Right-click Menu	Delete (Collector)
Right-click Menu	Scan
Right-click Menu	Properties
Right-click Menu	Save
$image\B_FirstSQL.gif$ $image\B_PreviousSQL.gif$ $image\B_NextSQL.gif$ $image\B_LastSQL.gif$	First SQL / Previous SQL / Next SQL / Last SQL
SQL Menu	Find SQL
SQL Menu	Find Next SQL
Edit Menu $image\B_SendToSQLOptimizer.gif$	Send to SQL Optimizer
Edit Menu $image\B_CopytoIndexAdvisor.gif$	Send to Index Advisor
Edit Menu $image\B_CopyToSQLWorksheet.gif$	Copy to SQL Worksheet
File Menu	Save SQL to SQL Repository
View Menu	All SQL
View Menu	Simple SQL
View Menu	Complex SQL
View Menu	Problematic SQL
View Menu	SQL without Plan
Report Menu	Monitored SQL

SQL Scanner

SQL Scanner Overview

SQL Scanner > SQL Scanner Overview

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.

製品を選択してください:

サービス向上のために、「Purpose of your Chat（チャットの目的）」を記入してください。

お客様の不具合に推奨されるソリューション

SQL Optimizer for SAP ASE 3.9.1 - User Guide

Collector Properties

SQL Collector Functions

SQL Scanner

SQL Scanner Overview