Sharing System Memory

[Gamaliel]

Hi Folks,

My server has 14 GB of physical Memory.

It's a database dedicated server.

It's running a Sybase ASE 15.0.1 database with 6 GB asigned.

The distribution of memory is:
5.3 GB System
1.4 GB Buffer
1.3 GB Free

I expected that I can give 10 GB to the database... so:
-) Have I misconfigured the server parameters so the system is wasting a lot of memory?
-) Is healthy to have the same amount of memory for the db and the system?

Best Regard from Mexico!

[Dennis Handly]

What HP-UX version are you running? Are you up to date with your VM patches?

The system may be caching lots of data because you aren't making more demands on it?

[Gamaliel]

Hi DH,

HP-UX 11.11

The database inside (within the 6 GB asigned) uses a cache area.

[Dennis Handly]

>The database inside uses a cache area.

I was thinking about the buffer cache and other system caches.

>The distribution of memory is:

What tool did you use to get this?

[John Guster]

please post the output of commands
1. /usr/sbin/kmtune|grep dbc
2. swapinfo -mat

[Gamaliel]

Hi DH, JG,

The tool to mesure the memory is glance.

# kmtune|grep dbc
dbc_max_pct 10 - 10
dbc_min_pct 5 - 5
# swapinfo -mat
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4096 29 4067 1% 0 - 1 /dev/vg00/lvol2
dev 14000 29 13971 0% 0 - 1 /dev/vg00/lv_swap
reserve - 6037 -6037
total 18096 6095 12001 34% - 0 -