1833894 Members
1568 Online
110063 Solutions
New Discussion

Re: performance problem

 
I.Delic
Super Advisor

performance problem

Hi,
We have a L2000 server.OS is HP-UX 11.11i and we have put 1GB RAM memory in this sever.
We use this sever for our database ( progress).
We have some performance problems. First i saw dat my terminal session works slowly but if i start my session on the console i have the same problem. It is not always but sometimes. I saw that my VHAND proces is very actief. If i start SAR 5 5 then i get wi/0 very big and idle is 0.
We changed a few parameters.

maxuser was 32 and now it is 125
semmns was 128 2048
semmnu was 128 2048

I don't know what can be the problem. I don't have mutch expirance on UNIX but i know what we did change.
When i got this server everything was ok . Then we changed those parameters and now i have a problem. I don't know of this maybe the couse off my problems.
We did install samba server on this machine but if i stop samba server i have the same problem.
I saw that my server does a lot of swap .

can somebody help me

Thank you
14 REPLIES 14
Michael Steele_2
Honored Contributor

Re: performance problem

Max semmns is defined by the size of RAM, default = 128, and should be less then or equal to (semmni * semmsl)

Max semmnu is nproc-4, default = 30.
Support Fatherhood - Stop Family Law
Patrick Wallek
Honored Contributor

Re: performance problem

If your vhand process is very active, then chances are you are paging. 1 GB of RAM is not much RAM for a database server.

Post the output of:

# swapinfo -tam

I.Delic
Super Advisor

Re: performance problem

hi,

here is my swapinfo -tam
Michael Steele_2
Honored Contributor

Re: performance problem

Regarding "...I saw that my server does a lot of swap..."
I believe that your swap is just fine based upon this.

Did you change your 'semmns' and 'semmnu' to a value within the ranges indicated?

If problem continues then please attach these reports:

sar -v 5 5
sar -d 5 5
sar -u 5 5
vmstat 5 5
Support Fatherhood - Stop Family Law
Patrick Wallek
Honored Contributor

Re: performance problem

You are using 42% of your swap space. That will slow down your machine drastically.

I would look at adding more memory to the machine. With the price of memory nowadays, I see no real reason why you should EVER use any swap space at all, especially on a machine of this type.

If HP memory is too expensive for your taste, check Kingston ( http://www.kingston.com ). I have used their stuff and it works great.
A. Clay Stephenson
Acclaimed Contributor

Re: performance problem

Patrick has nailed it for you. You are never going to be satified with the performance of this box until you increase memory. 1GB is considered very small these days.

One tool to use (if you don't have Glance) is vmstat. The only column of any real value is "po" (pageout). That should be very nearly zero or you will have a dog.

If it ain't broke, I can fix that.
I.Delic
Super Advisor

Re: performance problem

Thank you
Ross Zubritski
Trusted Contributor

Re: performance problem

Also check dbc_min and dbc_max. Make sure that they are not set to default. I would set min to 2 and max to 5 in your case.

Regards,

RZ
Dario_1
Trusted Contributor

Re: performance problem

Hi

I will also recommend Ross answer. Take a look at those parameters and make some corrections to see if that helps.

min 2 or 3
max 5

Regards,

DR
I.Delic
Super Advisor

Re: performance problem

Hi,

Hier is my vmstat file
James A. Donovan
Honored Contributor

Re: performance problem

You're system is starving for RAM. You're vmstat (btw, usually a single line of output from this util is not of much use in diagnosis) clearly shows you are running very low on free virtual memory pages. 1429 pages = about 5 MB of free virtual memory. You're actively using 1500 MB of virtal memory. Since you only have 1 GB of physical RAM, you must be swapping. This is a performance killer!

Buy and install at least 1 GB.
Remember, wherever you go, there you are...
Michael Steele_2
Honored Contributor

Re: performance problem

vmstat -s is also nice but this will also do for it indicates that po = 11 and if consistent, then you are paging and you have a capcity problem, which can be corrected by either adding more RAM or reducing the number of processes running on the server.
Support Fatherhood - Stop Family Law
I.Delic
Super Advisor

Re: performance problem

Hi,
Is it possible with not correct settings of
those parameters:

maxuser was 32 and now it is 125
semmns was 128 2048
semmnu was 128 2048

to slow down performance of my machine.

thank you
Jakes Louw
Trusted Contributor

Re: performance problem

Yes: increasing kernel params means that in many cases you are reserving RAM (memory) for system usage. This reduced the amount of memory that the application or users have access to.

On 1GB, I'd analyse each kernel param, and cut them to the bone.
Trying is the first step to failure - Homer Simpson