Chat now with support
Chat mit 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

SQL Inspector Privileges

SQL Inspector > SQL Inspector Privileges

To use the SQL Inspector module you must have access to the sysquerymetrics view in Adaptive Server 15.0 or later.

You must also set up specific configuration parameters in Adaptive Server.

 

Related Topic

Performance Statistics - Monitoring Tables

SQL Inspector > Performance Statistics - Monitoring Tables

Performance Statistics - Monitor Tables

Each SQL statement captured from the monitoring tables has the following performance statistics:

Statistics

Description

CPU Time

Number of milliseconds of CPU used by the statement.

CPU Time Per Execution

Ratio between the number of milliseconds of CPU used by the statement and the number of executions.

Executions

Number of times the statement was executed during the monitoring period.

Logical Reads

Number of buffers read from cache.

Logical Reads Per Execution

Ratio between the number of buffers read from cache and the number of executions.

Mem Usage (KB)

Number of kilobytes of memory used for the execution of the statement.

Mem Usage (KB) Per Execution

Ratio between the number of kilobytes of memory used for the execution of the statement and the number of executions

Packets Received

Number of network packets received by Adaptive Server.

Packets Received Per Execution

Ratio between the number of network packets received by Adaptive Server and the number of executions.

Packets Sent

Number of network packets sent by Adaptive Server.

Packets Sent Per Execution

Ratio between the number of network packets sent by Adaptive Server and the number of executions.

Pages Modified

Number of pages modified by the statement.

Pages Modified Per Execution

Ratio between the number of pages modified by the statement and the number of executions.

Physical Reads

Number of buffers read from disk.

Physical Reads Per Execution

Ratio between the number of buffers read from disk and the number of executions.

Wait Time

Number of milliseconds the task has waited during execution of the statement.

Wait Time Per Execution

Ratio between the number of milliseconds the task has waited during execution of the statement and the number of executions.

 

Related Topics

Performance Statistics - QP Metrics

SQL Inspector > Performance Statistics - QP Metrics

Each SQL statement captured from the QP Metrics has the following performance statistics:

Statistics Description

Execution time

How long it takes to execute the SQL statement on the CPU displayed in milliseconds.

Elapsed time

This is a total of the Execution time and the time it takes to parse, compile, and optimize the SQL statement displayed in milliseconds.

Logical IO

Total logical IO reads during the execution of the SQL statement.

Physical IO

Total physical IO reads during the execution of the SQL statement.

Execution count

Number of times the SQL statement has been executed.

Abort count

Number of times the resource governor terminated the SQL statement because a resource limit was surpassed.

The execution time, elapsed time, logical IO, and physical IO statistics each of have three values taken from the number of times the SQL statements was executed: the minimum, the maximum, and the average.

 

Related Topics

Data Directory Setting

SQL Inspector > Data Directory Setting

The SQL Inspector data directory is where the data files are created while executing the Inspect function. The data directory path is set in the Preferences window.

  1. Click image\B_Preferences.gif.

  2. Select the Directory Setup tab.

The default setting for this directory is:

C:\Documents and Settings\User\Application Data\Quest Software\Quest SQL Optimizer for SAP ASE\DATA

Changes to this directory cannot be made while the SQL Inspector is active.

Note: It is advisable not to change the data directory after you have used this function, as files created during inspecting are kept in this directory.

 

Related Topic

Verwandte Dokumente

The document was helpful.

Bewertung auswählen

I easily found the information I needed.

Bewertung auswählen