SQL/MP Installation and Management Guide

Measuring Performance
HP NonStop SQL/MP Installation and Management Guide—523353-004
13-5
Measure Performance Measurement Tool
SQLSA statistics are not cumulative. For example, while a CURSOR is open, the
statistics reported apply only to each specific SQL statement issued, such as the
OPEN statement and each individual FETCH statement, not to the entire set of
operations spanning the use of the cursor from open to close. To accumulate statistics
for a sequence of operations, you must maintain separate counters and add to them
after each SQL statement that affects the SQLSA.
The SQLSA also receives statistics on prepared dynamic SQL statements. These
statistics include the number of input and output variables, the length of the buffer
required for input and output variables, and the length of a buffer for name maps.
For additional information on using the SQLSA, see the SQL/MP Programming Manual
for your host language.
Measure Performance Measurement Tool
Use the Measure product to collect statistical information on SQL database objects and
SQL processes (host language programs with SQL statements) and to generate
reports. You select a process for measurement by specifying the process in a Measure
ADD command in effect when the process executes.
You can collect performance statistics for SQL/MP objects by using these Measure
entities:
•
SQLPROC provides information about an SQL process. There is one SQLPROC
counter record per SQL process selected.
•
SQLSTMT provides information about all SQL statements within an SQL process.
There is one SQLSTMT counter record per SQL statement of a selected SQL
process.
•
FILE allows an SQL database object to be selected for accumulating information
about file activities.
Figure 13-1
on page 13-6 illustrates Measure entities and corresponding program
structures for SQL processes.