Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - User Guide

Introduction Tutorials Preferences Editor Functions SQL Information and Functions Performance Monitor SQL Inspector SQL Collector for Monitor Server SQL Scanner Index Advisor SQL Optimizer
SQL Optimizer Overview Optimization Engine Common Coding Errors in SQL Statements What Function Should l Use to Retrieve the Run Time? Unsatisfactory Performance Results SQL Optimizer Functions SQL Editor Optimized SQL Activity Log
SQL Worksheet SQL Formatter Database Explorer Code Finder Object Extractor SQL Repository Index Impact Analyzer Index Usage Analyzer Configuration Analyzer Migration Analyzer Abstract Plan Manager User-Defined Temp Tables SQL History Legal Information

Collector Properties

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.

 

Related Topics

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

 

Related Topics

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 statements 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.

 

Related Topics

Scan

Related Documents