Chat now with support
Chat with Support

SQL Optimizer for SAP ASE 3.9.1 - Installation Guide

Performance Statistics - Monitoring 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

SQL Inspector Overview

SQL Inspector Window

Performance Statistics - QP Metrics

Add/Modify Inspector

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating