SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Measuring Performance
HP NonStop SQL/MX Installation and Management Guide—523723-004
15-6
Statistics and Reports for NonStop SQL/MX
Statistics and Reports for NonStop SQL/MX
Use the Measure entities to gather statistics on an SQL/MX database and application
programs. After gathering the statistics, you can generate reports about the statistics.
Information gathered by the entities is described next.
SQLPROC Statistics
The SQLPROC report provides information about 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.
SQLSTMT Statistics
The SQLSTMT report provides information for specific statements of an SQL process.
SQLSTMT entities gather statistics for all statements of a process selected for
measurement. One SQLSTMT entity exists for each statement. The SQLSTMT report
contains the module name and the statement index that you can use to identify the
statement in a compiled module. See the embedded module definition or the module
definition file for a list of statement indexes and associated statement names. For a
dynamic SQL statement, the module name appears as
SQLMX^EXECUTE_statement-name, and the statement index is zero.
The SQLSTMT report gathers statistics on these measurements:
•
Busy time
•
Calls
•
Disk reads
•
Lock waits
•
Message activity
•
Records accessed
•
Records used
Stream access statements do not collect SQLSTMT statistics, but FILE statistics are
collected.
FILE Statistics
Monitor database files with the FILE entity. The FILE report provides information on
specific file and record use by a user process. The FILE report gathers statistics on
these measurements:
•
Escalations of locks
•
Deletes
•
Disk reads
•
Lock waits
•
Message activity