Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.8 - 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

Information Tab

Performance Monitor > Performance Monitor Preferences > Information Tab

The Information tab on the Preferences window for the Performance Monitor determines which of the top SQL statements are highlighted, sets highlighting colors, and sets the automatic display of the connection information when logging on.

SQL statement

In the left pane of the Performance Monitor window, individual SQL statements are displayed when you drill down from Information to Process Information to the Executing SQL Statements. The following settings determine how many SQL statements are highlighted, by what criteria they are sorted, and the color that is used for highlighting.

Highlight Top N SQL Statements (Default = checked)

The top SQL statements are highlighted for you to quickly identify which SQL statements are consuming the most resources.

Top-N (Default = 10)

Specify the number of SQL statements to be highlighted.

Order By (Default = CPU Time(ms))

Select the statistic to sort the SQL statements from the drop-down field.

Highlight Color (Default = Yellow)

Select the color from the drop-down field.

Highlight selected column

When you drill down to the lowest level of the charts, the data from the table displays in a grid underneath the chart. The column for the statistic that is selected in the left pane is highlighted.

Highlight Color (Default = Sky Blue)

Select the color from the drop-down field.

SQL Filter (executing SQL only)

Ignore SQL executed from SQL Optimizer Default = checked)

Specify to exclude the SQL statements that are generated by any of the modules in SQL Optimizer but the Performance Monitor.

Ignore SQL executed from Performance Monitor (Default = checked)

Specify to exclude the SQL statements that are generated by the Performance Monitor.

Display Connection Information window only when insufficient privileges (Default = checked)

Specify to display the Connection Information window each time you logon if the user logon does not have the database privileges needed for the modules.


Related Topics

Top-N Display Tab

Performance Monitor > Performance Monitor Preferences > Top-N Display Tab

The Top-N Display tab on the Preferences window for the Performance Monitor is for determining the percent of each statistics that is retrieved from the monitoring tables.

To select only the top statistics

Select the button on the left for the statistics information and fill in the values on the right for each individual statistic.

Please reference the Adaptive Server Performance and Tuning: Monitor and Analyzing manual for the meaning of each statistic.


Related Topics

SQL Inspector

SQL Inspector Overview

SQL Inspector > SQL Inspector Overview

The SQL Inspector identifies SQL statements with performance problems by extracting SQL statements and SQL performance statistics from the QP Metrics (Adaptive Server 15 or later). The SQL Inspector graphically displays and compares SQL activity statistics to diagnose performance bottlenecks. With the SQL Inspector you can identify the top N most resource intensive SQL statements.

With the SQL Inspector, you can schedule the date and time and the frequency that the SQL statistics are collected in order to identify the impact of SQL activities on database performance. By displaying the statistics on a graph you can see which SQL statements are consuming the most database resources, hence identifying problematic SQL statements quickly and efficiently.

The SQL Inspector window provides a work area for you to add and delete Inspectors, storing information on the Inspector name and description, number of SQL captured, start time, end time, and duration. It offers a way to view the statistics from the SQL statements captured in charts and a grid format. It provides a view of the top N worst performing SQL statements. SQL statements can be sorted by different AND/OR conditions of SQL performance statistics such as number of executions, CPU time, logical reads, physical reads, and others.

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 from the SQL Inspector to the SQL Optimizer, Index Advisor, the SQL Worksheet, or save them to the SQL Repository.

Note: This module is available for Adaptive Server 15 and later and requires that the Adaptive Server monitoring tables are installed.

Or, if you have Adaptive Server 15.0 or later, you can retrieve the SQL statements and performance statistics using QP Metrics if you have access to the sysquerymetrics view.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating