- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: HP-UX Performance Issue
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-23-2001 05:07 PM
тАО05-23-2001 05:07 PM
HP-UX Performance Issue
We are running T600 machine with oracle database ( 7.2.3), 3 GB of memory and 4 CPU. We encounter system slowness during peak. Could anybody help on resolving this issue.
# swapinfo -t
Kb Kb Kb PCT START/ Kb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 524288 145208 379080 28% 0 - 1 /dev/vg00/lvol2
dev 524288 146596 377692 28% 0 - 1 /dev/vg00/lvol3
dev 4096000 146016 3949984 4% 0 - 1 /dev/vg00/lvol12
reserve - 812064 -812064
memory 2297936 1594416 703520 69%
total 7442512 2844300 4598212 38% - 0 -
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-23-2001 05:43 PM
тАО05-23-2001 05:43 PM
Re: HP-UX Performance Issue
When you have this 'baseline' (ie, standard performance during non-peak times).. you can compare the processes, memory/swap, disk i/o, and see what has increased alot....
This will hopefully show you where the user reponse time is being dragged down the most...
Once you've identified this, you need to think about how you could improve the performance of this bottleneck... (by getting faster disks, more memory etc etc...)
Hope this helps !
Andrew
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-23-2001 06:09 PM
тАО05-23-2001 06:09 PM
Re: HP-UX Performance Issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-23-2001 06:47 PM
тАО05-23-2001 06:47 PM
Re: HP-UX Performance Issue
The T600 is fairly old technology and it appears that you may have hit the limit of this processor and the load you require. An A-class or L-class will remove address limits and move processing power to today's standards. Alternatively, you can move unnecessary applications to other systems to relieve the load.
Note that the most significant performance changes can be made with better database design and configuration, much more so than working on HP-UX.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-23-2001 06:50 PM
тАО05-23-2001 06:50 PM
Re: HP-UX Performance Issue
What is your dbc_max/min_pct set to ??
If you've got max set very high, then the buffer cache will take heaps of memory, and not free it very quickly..
See Doc ID A4460661 for more details...
Hope this helps !
Andrew
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-23-2001 06:55 PM
тАО05-23-2001 06:55 PM
Re: HP-UX Performance Issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-23-2001 08:08 PM
тАО05-23-2001 08:08 PM
Re: HP-UX Performance Issue
D. Tuning the File System Buffer Cache.
The problem has been determined to be either a file system I/O
bottleneck or a memory bottleneck. In either case, adjusting
the size of the buffer cache may resolve the problem. It is
easiest to measure the effectiveness of the buffer cache and
the effectiveness of changes if the buffer cache is of a fixed
size, instead of the 10.x default of a dynamic buffer cache that
ranges in size from 5 to 50% of main memory. The size of the
buffer cache is controlled by the kernel parameters bufpages,
nbuf, dbc_max_pct, and dbc_min_pct.
SAM help can provide more information on these parameters, and
the System Administration Tasks manual has information on how
to rebuild the kernel. Historically, HPUX has used 10% of main
memory as a default buffer cache size.
The goal of the buffer cache is to increase the speed of disk I/O
reads and writes. The trade off for that increased performance is
the usage of a percentage of main memory. After isolating the
resource that is slowing the system, the job is to adjust the
size of the buffer cache to get the best returns for this system.
------------
With 3 gig of RAM, I would say that you could safely reduce your max buffer cache... You'll probably find that your processes are swapping alot because the buffer cache is taking up too much space in memory (if it does actually grow to 50% - which is quite possible)...
I would experiment with reducing the max, to say 20%, and see if that reduces the amount of paging your system does...
There is a memeory management white paper at :
/usr/share/doc/mem_mgt.txt
use this guide for more information on tuning your memory.. But the reducing dbc_max_pct would be the first place to start...
Hope this helps !
Andrew
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-27-2001 10:55 AM
тАО05-27-2001 10:55 AM
Re: HP-UX Performance Issue
In a database doing anything but simple reads, your transaction logs are being written to constantly...
Therefore, those transaction logs should be on the fastest possible disk subsytem... (of course it should be reliable too..)
Similarly, if you are doing a large number of writes, your database would benefit from being on 'the fastest disks possible'
Here is the gotcha - you really have to understand your usage patterns... it may be faster to have your databases spread across 3 slower disks, rather then everything on one really fast disk..
Similarly, it is CONCEPTUALLY possible to spread swap over several drives, rather than having a few massive swap volumes... in fact I don't know whether this is really useful on HPUX, possible on HPUX, or useful for you.
Unfortunately... I don't know how to ask/answer the question 'is disk i/o a bottleneck' on HPUX.
Good Luck.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-27-2001 11:11 AM
тАО05-27-2001 11:11 AM
Re: HP-UX Performance Issue
Database performance (in general) can be improved or worsened by using INDEXES.
I frankly know NOTHING about Oracle.
If you are doing many inserts, i.e. a transactional database, then you want FEW, well chosen indexes.
If you are doing primarily reads (datamining) then lots of concise indexes might serve you well.
How queries are written can have a big impact, in principle. Some database engines well re-order or re-write queries on the fly to try and find the best indexes to cover queries, so you may not really want to mess with queries. However, it may be worthwhile to train your user or developer community in what is a 'good query' (for your database.)
In some database engines you may have tables that simply are not allowed to change - and could in principle be marked read-only. If this is possible in your scenario, you may find some performance benefit by marking tables as read-only. By the way, if the table is read only, excess indexes won't hurt anything (well, they will suck up disk space)... you aren't making changes here anyway...
As mentioned elsewhere, moving unneccary services off of the box is a good idea...
If DNS is on this box, as an easy example, install it on another box... you may want to keep DNS on this box during a migration, or permanently, but every DNS query you would move off on to another platform would be 'free CPU cycles.'
Of course getting rid of excess services (in my example DNS) entirely would free up memory too - and it sounds like you cannot add memory, you can only take away demands on memory.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-27-2001 01:14 PM
тАО05-27-2001 01:14 PM
Re: HP-UX Performance Issue
As has been suggested you need to reduce your buffer cache. max_dbc_pct at 50% is way too high for a database server. If your are using raw disk I/O or OnlineJFS options convosync=direct,mincache=direct which are in effect the same as raw disk then you should really reduce the unix buffer cache since you are in effect double buffering I/O in both the SGA and the UNIX buffer cache. If this box is primarily a database server, I would forget about dynamic buffer cache and set bufpages to about 300MB (and this is generous) and them measure performance.
As has also been mentioned, your T-box is old and even an A-box would blow it away in terms of performance.
Food for thought, Clay