Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Troubleshooting Guide

- Previous: Are There Enough Locks?
- Next: Connection Problem Caused by Lack of Semaphore Resources

## Can You Fix the Problem by Doing Some Performance Tuning?

In most situations, reducing load or increasing the availability of resources will improve host performance. Some of the more common steps to take are:

- Run the nodes on hosts with better hardware characteristics (more internal memory, higher processor speed, more processors).

- Add physical disks and use several data devices, not more than one device on each physical disk.

- Add more nodes, on new hosts, and refragment the data to utilize the new nodes.

- Change configuration variables to allocate larger memory segments or internal data structures.

In addition, the following resources can be adjusted to improve “`HIGH LOAD`” problems, as described in the Performance and Tuning Guide:

Table 3–1 HADB Performance Tuning Properties

Resource | Property
--- | ---
Size of Database Buffer | `hadbm attribute DataBufferPoolSize`
Size of Tuple Log Buffer | `hadbm attribute LogBufferSize`
Size of Node Internal Log Buffer | `hadbm attribute InternalLogBufferSize`
Number of Database Locks | `hadbm attribute NumberOfLocks`

- Previous: Are There Enough Locks?
- Next: Connection Problem Caused by Lack of Semaphore Resources

- © 2010, Oracle Corporation and/or its affiliates