How can I increase my HPUX 11.11 performance?

[cbozlagan]

How can I increase my HPUX 11.11 performance?

My HPUX system is slow (2 * PARISC CPU, 6GB)

Which checking must I do?

I do not need hardware solution (Memory increasing etc.)

Thanks.

[spex · Accepted solution]

It doesn't get much vaguer than that.

HP-UX Performance Cookbook
http://h21007.www2.hp.com/dspp/files/unprotected/devresource/Docs/TechPapers/UXPerfCookBook.pdf

[Steven E. Protter]

Shalom,

This is also a very good document. Oriented toward Oracle.

http://www2.itrc.hp.com/service/cki/search.do?searchString=UPERFKBAN00000726&docType=Security&docType=Patch&docType=EngineerNotes&docType=BugReports&docType=Hardware&docType=ReferenceMaterials&docType=ThirdParty&searchCrit=allwords&search.x=28&admit=-1335382922+1179404575187+28353475&category=c0&mode=id&search.y=8

SEP

[Yogeeraj_1]

hi,

You will also need to tell us about which areas you are experiencing performance degradation.

CPU, RAM or IO

- What type of application are you running?
- When is your system slow? Is it temporal, etc..

revert

kind regards
yogeeraj

[cbozlagan]

Hi,

My Application is SAP NetWeaver 2004s SR2 with Oracle 10g 10.2

I'm comparing HPUX system to Windows Server 2003 (Same application runs under Win 2003)

I compared parameters NetWeavers. All parameters are the same. But NetWeaver on Win2003 is 4 times faster that NW on HPUX.

I studied oracle parameters, but parameters are the same.

When I login HPUX it is very slow.

I was expecting HPUX much more faster Win2003 server.

Thanks

[cbozlagan]

Hi Steven,

Url you sent
It says 'System Unavailable'

[Rita C Workman]

OK, it would appear you are not familiar with tuning an HPUX kernel.

First thing. Gather what your applications requires. I think in terms of Oracle, so SGA, semmaphores, etc. Last I recall on SAP was that it required alot of swapspace to be set up. If that is still accurate, find out how much your appl wants and set it up.

Next....first thing I change in a fresh kernel is the dbc_min/max_pct from the default settings:
For 6Gb, maybe put db_max_pct to something around 12 to 15
For db_min_pct put it at maybe 5 to 8

Then go to http://docs.hp.com/en/1219/tuningwp.html and start reading. Might also consider attending some Kernel Tuning training classes that HP offers. It's well worth the $$.

Hope this helps get you started. Remember tuning is something you do a little at a time. Don't change alot at one time. And remember.....higher numbers don't always help !!! Sometimes the best gains are made by reducing the setting, not increasing.

There are plenty more easy fixes on parms, but this is a start for you.

Rgrds,
Rita

[Duncan Edmonstone]

I know you say don't mention hardware, but what exactly are the specs of the 2 boxes in question?

How many CPUs of what type in the windows box? How much memory? Windows x86 or x64? What sort of storage is your database sitting on?

You say 2 x PA-RISC CPUs - but of what type? Its possible to have a 10 year old system with 2 PA-RISC CPUs and 6GB of memory and I would expect a reasonably modern Proliant to be faster than that!

HTH

Duncan

[dirk dierickx]

add more memory.
add more cpu or replace with faster cpu.
optimize your disk and/or filesystem layout for more performance.

the above are always true :D

[Bill Hassell]

> I compared parameters NetWeavers. All parameters are the same. But NetWeaver on Win2003 is 4 times faster that NW on HPUX.

> I studied oracle parameters, but parameters are the same.

In both cases, configuration parameters aren't enough. Do the databases have identical indexes and are the indexes balanced? If HP-UX has been running for a long time, you may discover that your version of Oracle is silently using index-partial searches because the indexes are badly out of balance. Exporting the same database to the Windows box properly balances the new indexes.

This is only one example of "they are the same" when the two systems are quite different. Rebuild all the indexes.

> I do not need hardware solution (Memory increasing etc.)

You can't determine anything about adequate RAM and CPU count without measurement tools. You'll need Oracle's StatsPak or AWR to see if there is anything you can do to improve the overall system. Comparing a specific instance of an application to another, whether it is Windows or Linux or mainframe, is doomed to bad decision-making.

[Steven E. Protter]

Shalom,

lots of things can make login slow.

I had a situation with an HP-UX box, that was wicked fast. It has a web based mail app on it and was slow as molasses, even with 1 user on it.

I'd recently reconfigured the firewall it was behind and was using the firewall in /etc/resolv.conf to get name resolution.

Well that was the problem. I needed to use the same /etc/resolv.conf as the firewall and suddenly everything was snappy as could be.

Host resolution is a hidden performance killer. When I looked at my logs, sendmail was thrashing trying to get host resolution and thats what made everything so slow.

I would not recommend more memory until you are sure you are out of memory. http://www.hpus.ws/system.perf.sh

Comparing the windows box to the HP-UX box is meaningless. The CPU's are totally different, the bus speed is totally different, everything under the hood is totally different and you problem might be host resolution, might be bad application code.

Its detective time. We've given you the tools, now you have to start investigating, looking at logs.

Without using the tools and doing some analysis, its unlikely a magic answer is going to spring up from this thread.

Please start doing the investigation and post your findings if you don't understand the data. Then you'll get this thing solved.

SEP

[Steven E. Protter]

Shalom,

lots of things can make login slow.

I had a situation with an HP-UX box, that was wicked fast. It has a web based mail app on it and was slow as molasses, even with 1 user on it.

I'd recently reconfigured the firewall it was behind and was using the firewall in /etc/resolv.conf to get name resolution.

Well that was the problem. I needed to use the same /etc/resolv.conf as the firewall and suddenly everything was snappy as could be.

Host resolution is a hidden performance killer. When I looked at my logs, sendmail was thrashing trying to get host resolution and thats what made everything so slow.

I would not recommend more memory until you are sure you are out of memory. http://www.hpus.ws/system.perf.sh

Comparing the windows box to the HP-UX box is meaningless. The CPU's are totally different, the bus speed is totally different, everything under the hood is totally different and you problem might be host resolution, might be bad application code.

Its detective time. We've given you the tools, now you have to start investigating, looking at logs.

Without using the tools and doing some analysis, its unlikely a magic answer is going to spring up from this thread.

Please start doing the investigation and post your findings if you don't understand the data. Then you'll get this thing solved.

Note that in the host resolution example above, adding memory would have done absolutely no good. Adding a CPU would have done absolutely no good.

SEP

[Jov]

Hi,

Beside everything mentioned above, have you considered the configuration and parameter settings used might be geared towards a Windows platform?

If you're using Windows 2003 Standard Server, you're limited to 3.5GB to the entire system where as you can use most of the 6GB on HP-UX. Horses for causes mate.


Jov