WebSphere WebSphere Application Server Network Deployment, Version 6.1.x Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows, z/OS

Data store performance

Several factors can affect the performance of a data store, when data store is chosen as the message store for a messaging engine. For example, operations on databases.

The workload that the messaging engine imposes on the relational database management system (RDBMS) is somewhat different from usual database workloads, because the messaging engine performs mainly SQL INSERT and DELETE operations. Take this workload into consideration when using the tuning guidelines supplied by your RDBMS provider. The following information might also assist your database administrator.

Each messaging engine can request a large number of concurrent connections to the database. By design, a messaging engine uses many threads to perform database updates concurrently. Consider configuring the connection pool for the JDBC data source used by the data store with sufficient connections to cope with peak workloads, for example, 50 connections. Your database administrator might need to change the database configuration to support this number of concurrent connections from the application server.

The performance of the data store influences messaging throughput to a significant extent. Throughput is usually limited by the write latency of the database log. Consider placing the database log on a fast, dedicated device that is configured for optimal write performance. Ideally, use a storage controller with a battery-backed memory cache so that the effects of disk rotation speed and seek latencies are not evident. For all except entry-level systems, use a RAID controller.

DB2 tip:

To get the best performance from messages in the 3KB to 20KB range, you should consider putting the SIBnnn tables into a tablespace with 32KB pages and adjusting the column width of the VARCHAR column to 32032 bytes.

Related tasks
Tuning the JDBC data source of a messaging engine
Tuning and problem solving for messaging engine data stores

Concept topic

Terms of use | Feedback


Timestamp icon Last updated: 26 February 2009
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.pmc.nd.multiplatform.doc/concepts/cjm0470_.html

Copyright IBM Corporation 2004, 2009. All Rights Reserved.
This information center is powered by Eclipse technology. (http://www.eclipse.org)