- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: User Access Speed
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
тАО11-21-2003 06:33 PM
тАО11-21-2003 06:33 PM
User Access Speed
Got a problem with refernce to speed. Am running Progress 8.3 on a HP UX 10.20 K class Server with dual processor. The problem is that our database is only about 1 GB in size, our users run emulators from Windows workstations. We are getting complaints of late of very slow processing when running large reports (we usual have guys doing that).
Is this due to crunching of large amount data or maybe a config problem. We have around 16 GB of space on the server mirrored on 4 x 4 GB HDD.
Anyway to increase access and processing speed. Keep me posted.
Joe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-21-2003 07:25 PM
тАО11-21-2003 07:25 PM
Re: User Access Speed
# swapinfo -ta
Also, if you have glance, run it and check for any bottle neck!
or
#sar -u 5
to check the CPU process.
Also, check your kernel settings for the following:
dbc_max_pct
dbc_min_pct
use the command kmtune
hope this help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-22-2003 11:16 AM
тАО11-22-2003 11:16 AM
Re: User Access Speed
This could be due to a large number of things:
1) Anti-social queries. The reports (if they are doing large scans through the data on the database) could be causing a performance degradation, especially if you have more users running reports now than you used to, or the data has grown in size.
2) Bad database design/configuration. Its possible that the database configuration is not optimal for the data contained in it.
3) Bottleneck. If you have glance, use that to look at the system (glance gives you a much more in-depth look at your system than most other tools). If not, you;ll have to reply on vmstat, top, and sar to try and work out where the bottlenect may be.
The bottlenecks could be either memory, disk, or swap (at least those are the most likely).
I'd also take a look at dbc_min_pct and dbc_max_pct - these are usually left at the default, which is pretty useless. Set dbc_min_pct to 4 and max to 5, or even look at using bufpages instead and fixing the size of the buffer cache. It may free up some memory for you.
You could also try rebooting the system and get them to try to run the reports afterwards. If the performance is great, and you find you have more memory than before the reboot, then you have an application with a memory leak.
If, after investigating all of that you can't find anything obvious, I'm afraid you could be looking at memory and/or CPU upgrades.
Regards
Col
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-22-2003 11:33 AM
тАО11-22-2003 11:33 AM
Re: User Access Speed
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-22-2003 04:02 PM
тАО11-22-2003 04:02 PM
Re: User Access Speed
#make_tape_recovery -x inc_entire=vg00 -I -v
download it from here:
http://www.software.hp.com/portal/swdepot/displayProductInfo.do?productNumber=IGNITEUXB
About the kernetl settings:
dbc_max_pct 50
dbc_min_pct 5
Above are the defaults, decreasing the default settings without knowing the exact issue will kill the performance!
Read this document about tuning performance carefully before you do anything!
Good luck
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-24-2003 02:39 PM
тАО11-24-2003 02:39 PM
Re: User Access Speed
I took XMAN's advise and downloaded IGNITE...on installing using standard swinstall procedure and folowing the instructions given at the HP site, I am unable to start ignite at /opt/ignite/bin/ignite....all the files are showing zero bytes....???????
The other ideas I am trying out so I will get back to you on it..
CHeers,
Joe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-24-2003 02:46 PM
тАО11-24-2003 02:46 PM
Re: User Access Speed
# /opt/ignite/bin/make_tape_recovery -x inc_entire=vg00 -I -v /dev/rmt/0mn
Also when you run the above command, does it start successfully. I have seen a problem with one of the later ignite versions where there was a file missing.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-24-2003 04:01 PM
тАО11-24-2003 04:01 PM
Re: User Access Speed
The download could be corrupted or it could as Micheal indicated a missing file.
However, let's try it from here and make sure you ftp the file in Binary format to your hp-ux box!
http://www.software.hp.com/products/IUX/download.html
Hope this help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО11-24-2003 04:05 PM
тАО11-24-2003 04:05 PM
Re: User Access Speed
#/opt/ignite/bin/ignite
only if you want to configure your hp-ux as the IGNITE Server. Otherwise, to create a recover tape just run the following:
#make_tape_recovery -x inc_entire=vg00 -I -v
Also, the first time you run it, it'll ask for the PAX patche, download the patch number
that is associated with your OS version, install it and then run.
for 11.0 the pax patch is as following:
PHCO_25418 pax(1) cumulative patch
Good luck