SQL/MP Installation and Management Guide

Measuring Performance
HP NonStop SQL/MP Installation and Management Guide—523353-004
13-6
Statistics and Reports for SQL/MP
To reduce the cost of overhead for the Measure interface to SQL/MP, the Measure
product updates more than one counter per call. The overall cost of using the Measure
product depends on the frequency of the intervals for measurements and on the
number of active SQL statements. As the number of active SQL statements in a
program increases, the cost of performing measurements increases.
The Measure product provides other entities to measure activity on processes,
processors, and disk processes. For information on how to set up the Measure product
and prepare reports, see the Measure Reference Manual and the Measure User’s
Guide.
Statistics and Reports for SQL/MP
You can use the three Measure entities to gather statistics on an SQL database and
application programs. After gathering the statistics, you can generate reports about the
statistics. The following paragraphs describe the information gathered by the entities.
SQLPROC Statistics
The SQLPROC report provides information on specific statistics concerning
recompilations, NEWPROCESS calls, and opens of an SQL process.
You can monitor automatic recompilation time with the SQLPROC report so that you
can determine the best compiler option: RECOMPILEALL or
RECOMPILEONDEMAND. For a description of these compiler options and their effects
on performance, see SQL Compilation and Recompilation on page 10-6.
Figure 13-1. Measure Entities and Program Structures
Procedure 1
SQL Statement 1
SQL Statement 2
SQL Statement 3
Access T1, T2,T3
Procedure 2
SQL Statement 1
SQL Statement 2
SQL Statement 3
Access T1, T2,T3
SQLSTMT
SQLSTMT
SQLSTMT
SQLSTMT
SQLSTMT
SQLSTMT
SQLPROC
Process (Program)
Measure Entities
FILE
FILE
FILE
Tables
•••
VST009.vsd
T3
T2
T1