HPE Community
Operating System - HP-UX
1834705 Members
2348 Online
110069 Solutions
New Discussion

SyBase Application. How to configure to the optimal performance on a rp3440. HPUX 11.11

 
Edmund Wong_1
Occasional Contributor

‎03-02-2006 03:23 PM

‎03-02-2006 03:23 PM

SyBase Application. How to configure to the optimal performance on a rp3440. HPUX 11.11

Hi All,
Need advise on how to configure the HPUX to suit the operation of the Sybase, Adaptive Server Enterprise/12.5.3

As according to the HP Internal customer's monthly report, there are almost 100% of our memory being utilized by the system which represented 2GB of our total memory.

However, if based on the memory configurations, there is only 1GB of memory being allocated to our Sybase (database) server where the rest of 1GB memory should be free and available in the system. In other words, we should be seeing maybe 60% or 70% of memory usage in the monthly report, not 98% to 100% usage.

Could anyone kindly advise on this?

Thanks!

0 Kudos
Reply
2 REPLIES 2
Rajeev Shukla
Honored Contributor

‎03-02-2006 03:43 PM

‎03-02-2006 03:43 PM

Re: SyBase Application. How to configure to the optimal performance on a rp3440. HPUX 11.11

Try changing dbc_max_pct to 10 (from 50 which default) in kernel parameters.
0 Kudos
Reply
Steve Steel
Honored Contributor

‎03-02-2006 07:04 PM

‎03-02-2006 07:04 PM

Re: SyBase Application. How to configure to the optimal performance on a rp3440. HPUX 11.11

Hi

This ftp site will help

Memory Usage (What is using all of the memory?)

by:eric.herberholz@hp.com

Last modified: February 2, 2006

Full document is available at external ftp site: ftp://eh:spear9@hprc.external.hp.com/memory.htm


Steve Steel
If you want truly to understand something, try to change it. (Kurt Lewin)
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.