SQL/MP Query Guide

Analyzing Query Performance
HP NonStop SQL/MP Query Guide—524488-003
6-7
Using Measure
Using Measure
You can use the Measure product to gather statistics on an SQL database and
application programs. This subsection briefly describes the kinds of statistics that
Measure provides. For more information on using Measure, see the SQL/MP
Installation and Management Guide.
The Measure product provides statistics on process execution and on individual
statement execution.
Process Execution
For each process, the Measure product provides these statistics:
•
The number of times the entire SQL program was recompiled and the elapsed time
needed for the recompilation
•
The number of times static SQL statements were recompiled and the elapsed time
needed for recompilation
•
The number of times the SQL compiler and SQL catalog manager were started up
and the elapsed time to do this
•
The number of open requests issued by SQL and the elapsed time to do this
Statement Execution
The SQLSTMT report provides information for specific statements of an SQL process.
For each statement, the Measure product provides these statistics:
•
The number of times the statement was executed
•
The total elapsed time to execute the statement
•
The number of rows accessed and altered
•
The number of I/O operations
•
The number of disk reads needed for execution
•
The number and length of messages sent to execute the statement
•
The number of sorts performed and the elapsed time to do them
•
The number of recompilations and the elapsed time to do them
•
The number of timeouts, lock escalations, and lock waits
SQLSTMT entities gather statistics for all statements of a process selected for
measurement; there is one SQLSTMT entity for each statement. The SQLSTMT report
identifies the SQLSTMT section name for each statement.
In the report, a section name is identified by the procedure name and index #nn, which
relates to the SQL Section Paragraph number generated during the host language