OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: Configuration for better Performance?

From: Henrik Hempelmann (Henrik.Hempelmannsap.com)
Date: Thu Apr 15 2004 - 11:21:03 CDT

Falk Brügmann wrote:

> Summary: We are using SAP DB 7.4.3, are unhappy with its performance, and
> would greatly appreciate any hints and help leading to a better
> configuration.
>
>
> We have a SAP DB 7.4.3 database on Debian Linux, accessed by a Java web
> application in a cluster setup. The database is running on a 4 x 2.5Ghz Xeon
> machine with 2 GB RAM and separate disks for log volume, data volume and os
> / db.

falk,
just a few comments from my point of view

> The problem is, we are not quite happy with the performance of our setup
> yet. When a not-too-high number of users tries to access the application,
> the database comes under load pretty quickly (as measured by the Unix "top"
> command), and normally fast queries start to take several seconds.
load (average:) of the run queue or load (user%) of the CPUs?

> Our current configuration parameters are:
> . CACHE_SIZE = 100000
-> 800MB Cache, you should double the chache size on a 2GB machine

> The data and log volumes are plain files (not raw devices) sitting on an
> ext3 (journaled) file system.
assure data journals on ext3 are disabled

    Henrik

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb