JDBC Type 4 Driver Performance Tuning Guide for Version 1.0

HP NonStop JDBC Type 4 Driver
Performance Tuning Guide for Version 1.0
Page 4 Hewlett-Packard Company — 529619-001 November 29, 2004
• Tune the priority of the processes such as DP2, SQL/MX Compiler, SQL/MX
Executor. See the Mixed Workload Design Priority Guidelines white paper in
the NonStop Technical Library for additional information.
• Use the “CONTROL TABLE <table-name> PRIORITY <priority>” SQL/MX
control table statement to tune the priority for subsequent file system requests
to the Data Manager (DAM). See the SQL/MX Reference Manual for
additional information.
6 Hardware considerations
• Use the fastest Ethernet possible on the NonStop system. 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