JDBC Type 4 Driver Performance Tuning Guide for Version 1.1

HP NonStop JDBC Type 4 Driver
Performance Tuning Guide for Version 1.0
Page 4 Hewlett-Packard Company — 529619-002 April 8, 2005
5 SQL/MX Tuning Tip
• See the SQL/MX Query Guide.
6 Hardware considerations
• Use the fastest Ethernet possible. The 100-megabit-per-second operation offered
by the HP 3863 Fast Ethernet ServerNet adapter (FESA) on the NonStop system
is recommended.
7 TCP/IP Configuration
• Set the “DATAFORWARDCOUNT” and “DATAFORWARDTIMER” SLSA
subsystem values to 1. For additional information, see the LAN Configuration and
Management Manual.
8 Performance Measuring Tools
Several excellent performance measuring tools are available for analyzing the impact of
accessing a SQL/MX database through the Type 4 driver, including:
HPjmeter - HPjmeter is a free 100% pure Java tool for analyzing profiling
information generated by the JVM. HPjmeter
runs on the HP-UX, Solaris™, Windows®, and Linux
platforms. HPjmeter allows you to measure many aspects of your
JVM (CPU usage per method, memory usage, etc.). You can
download HPjmeter from
http://www.hp.com/products1/unix/java/hpjmeter/
Perfmon - Perfmon is available in the Windows environment and allows
you to open a performance console and monitor CPU, memory,
and thread usage. For more information, see the Microsoft website
at http://www.microsoft.com
Measure - The Measure performance monitor is available on NonStop
systems. Measure is a data collection and measurement tool that
provides a wide range of performance statistics on system
resources. You can use the Measure performance monitor to gather