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-4
Measure Performance Measurement Tool
You can display statistics for this statement by using the DISPLAY STATISTICS
command:
DISPLAY STATISTICS;
Start Time 2003/12/11 18:18:24.489
End Time 2003/12/11 18:18:24.677
Elapsed Time 00:00:00.188
Compile Time 00:00:00.046
Execution Time 00:00:00.142
Table Name Records Records Disk Message Message Lock
Accessed Used I/Os Count Bytes
SAMDBCAT.PERSNL.EMPLOYEE
62 62 0 2 15128 0
For a description of the statistics displayed, see the SET STATISTICS or DISPLAY
STATISTICS commands in the SQL/MX Reference Manual.
With the statistics generated by SET STATISTICS ON or by DISPLAY STATISTICS,
you can quickly monitor the performance of a specific statement on specific objects.
The information can help you:
•
Determine the comparative performance of similar objects. For instance, you can
determine the effect of a new index on a table compared to the performance
without the index, or you can determine the performance after an UPDATE
STATISTICS statement.
•
Display the statistics of various queries or DML statements.
•
Monitor the estimated cost of a compiled statement or an ad hoc query. The larger
the estimated cost, the greater the execution time. You can then investigate costly
SQL statements for additional indexes, for out-of-date statistics on referenced
tables, or for poorly designed queries.
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.
Note. When appropriate, Measure displays ANSI SQL names as output but does not currently
accept ANSI SQL names as input parameters. You must enter queries using Guardian names.
You can use the OSS gname command to display the Guardian environment file name of an
OSS file. Use the MXGNAMES utility to convert ANSI table names into Guardian file names,
as described in the SQL/MX Reference Manual.