- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Performance problems, Progress database on HP ...
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
тАО08-31-2001 10:15 AM
тАО08-31-2001 10:15 AM
I have a question for any admins who work with systems running Progress databases.
We recently moved from HP UX 10.20 to 11.0, and ever since we have seen "spikes" where a user (or several users) suddenly are frozen for up to a minute. Usually it resumes where it left off, but occasionally the user gets bumped off.
At the same time, we moved to a much faster server (a K460 instead of a G50), with more CPU's, bigger disks, etc..
I am starting the whole process of install Glance, etc., but since this application is new to this server, I don't have a healthy baseline to compare against.
Has anyone here encountered database performance issues on upgrading to HP UX 11.0 ?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2001 10:30 AM
тАО08-31-2001 10:30 AM
Re: Performance problems, Progress database on HP UX 11.0
I didn't work with the systems that had Ingres database. YThe spikes could be due to several factors. As I understand that you are configuring Glace+, check this thread to see if it can help you out.
I would suggest you to configure Ingres as an application (workload) in SCOPE/UX and analyze
it in detail.
http://forums.itrc.hp.com/cm/QuestionAnswer/1,1150,0x46e7d211e18ad5118ff10090279cd0f9,00.html
-Sri
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2001 10:51 AM
тАО08-31-2001 10:51 AM
Re: Performance problems, Progress database on HP UX 11.0
Faster server more cpu and new os, but performance problems all points to kernal config.
Periodic freezes point to buffer cache.
The attched doc should help.
Paula
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-31-2001 10:55 AM
тАО08-31-2001 10:55 AM
Re: Performance problems, Progress database on HP UX 11.0
(By the way, it is a Progress database, not Ingres)
If we are lucky, some other admin has made a similar O/S transition and can let us know if there were any issues such as kernel parameters or patches etc.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-28-2001 12:40 PM
тАО12-28-2001 12:40 PM
Re: Performance problems, Progress database on HP UX 11.0
Hope this helps - as late as it is.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-28-2001 02:23 PM
тАО12-28-2001 02:23 PM
SolutionWe were on 10.2
The Progress is 9.1 I think.
We have not had any performance problems, other then an ongoing printing head ache.
Printer jobs randomly do not finish, about one a week. But I am working on that.
There is a lot you can in the area of performance tuning on Progress.
But I am mostly a novice, so only if you are interested will send some articles on how to tune Progress databases.
(they are to big to post here)
You can try:
www.progress.com/support/techpapers/tuning.htm
If you do not have Progress tuned well, it will run poorly and even behave strangely. Ha ha, I know that from experience.
What application are you running?
Tro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-28-2001 06:50 PM
тАО12-28-2001 06:50 PM
Re: Performance problems, Progress database on HP UX 11.0
Note that there is no one cause so looking for specific patches that address the symptom may not have any effect in your situation.
Something else to look at is sequential access, something that always occurs during a backup (we're talking about files, not raw volumes), or during serial database access. Changes made to buffercache queueing in 10.20 and more so in 11.0 give preference to adjacent disk activity, which can sometimes lockout random tasks like bdf or login or vi for seconds to minutes.
To help with this symptom, a new kernel parameter called disksort_seconds was introduced to helpp reduce the delays. The tunable parameter can be set to 0, 1, 2, 4, 8, 16, 32, 64, 128 or 256 second(s). If "disksort_seconds" is 0 (default value), the time stamp is disabled, which means that time aspect is not taking effect.
Now picking a value is tricky...a low value such as 1,2 or 4 will tend to defeat the performance advantage of the buffercache's preference for sequential I/O. I would start with 8 and then armed with Glance, take a look at the disk queues. You won't need a baseline with Glance since users will tell you when the system is too slow. Use the 'o' screen to limit visible processes to interesting ones, perhaps 5 secs of CPU and 5 I/O's per second.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 01:08 AM
тАО05-21-2003 01:08 AM
Re: Performance problems, Progress database on HP UX 11.0
We have recently upgraded from 10.20 to 11.0 32-bit and are using Progress 8.3e. Unfortunately since the upgrade we are having the same freezing problem as Jay. I was just wondering Jay if you could perhaps let me know if you found a solution.
Alsowe are currently trying Bills solution. Last weeks we changed disksort_seconds to 8 but this didn't help so last night we moved it to 16.
Please help as no-one at HP or Progress seem to know a solution.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-13-2003 07:56 AM
тАО06-13-2003 07:56 AM
Re: Performance problems, Progress database on HP UX 11.0
As is, it appears the main problem was that, as we added more application users, we consumed all the available read buffers allocated on the Progress database.
(The default is 150.)
We brought the number of read buffer up to 8K, and immediately saw a marked improvement in performance.
Here is the change that was required:
Old startup command for the database :
/opt/dlc/bin/proserve
New startup command for the database :
/opt/dlc/bin/proserve
The suggestions regarding kernel tuning were appreciated, but we found that the values already had been set to appropriate numbers.
Running Glance and sar was inconclusive, as the problem was intermittent and generally did not last long enough to gather statistics.