- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Performance problems with HP-UX 11.31 and Sybase
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
тАО04-22-2009 09:35 AM
тАО04-22-2009 09:35 AM
We are crippled. A test procedure can complete in 5 minutes on the old system, but takes 12 minutes on the new system. The storage system for both is the same EMC Clariion CX3-40C.
I have read the thread:
http://forums13.itrc.hp.com/service/forums/questionanswer.do?threadId=1209129
I welcome any additional advice while we pursue the other thread's information.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2009 09:46 AM
тАО04-22-2009 09:46 AM
Re: Performance problems with HP-UX 11.31 and Sybase
Thanks for opening another thread... sorry for being a stickler there, but I think it helps.
So from what you posted before I'm assuming you *are* using PowerPath 5.1 on this 11.31 host?
My first reaction would be - why? I'm not sure PP adds anything on 11.31 that isn't provided by the OS, unless EMC can explain some value to me...
So secondly if you are using PP5.1, can you confirm that you are using the legacy DSFs (/dev/dsk and /dev/rdsk rather than /dev/disk and /dev/rdisk).
And can you confirm that native multipathing for legacy DSFs is disabled?
HTH
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2009 09:58 AM
тАО04-22-2009 09:58 AM
Re: Performance problems with HP-UX 11.31 and Sybase
When I run ioscan, it shows the legacy DSF's
I don't know what you mean about native mulitpathing for legacy DSF's is disabled? We don't have any alternate links showing up when I run vgdisplay.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2009 11:17 AM
тАО04-22-2009 11:17 AM
SolutionI'm assuming the devices listed in your VG configuration are also legacy DSFs?
Anyway to check that legacy DSF MPIO is disabled, first identify the agile DSFs for your legacy DSFs using:
ioscan -m dsf
Then check the atttribute for each disk as follows:
scsimgr get_attr -D /dev/rdisk/diskX -a leg_mpath_enable
You should expect all the clariion devices to be set to false
HTH
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2009 11:23 AM
тАО04-22-2009 11:23 AM
Re: Performance problems with HP-UX 11.31 and Sybase
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2009 11:28 AM
тАО04-22-2009 11:28 AM
Re: Performance problems with HP-UX 11.31 and Sybase
A good starter would be to compare the job on the old box vs on the new one... how do you kick the job off? From the command line? Are you in a position to compare resource utilisation on both systems for the same job?
HTH
Duncan
I am an HPE Employee
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2009 11:31 AM
тАО04-22-2009 11:31 AM
Re: Performance problems with HP-UX 11.31 and Sybase
o Server 2: Sybase ASE 15.0.2 ESD#6 on HPIA 11.31 Itanium
o Each server was configured with 2 engines.
o The test consisted of executing 200 iterations of a stored procedure that is used frequently in our application. We ran 3 simultaneous sessions.
o The test completed in 7 minutes on the 12.5.3 server.
o It completed in 13 minutes on the 15.0.2 server.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2009 11:37 AM
тАО04-22-2009 11:37 AM
Re: Performance problems with HP-UX 11.31 and Sybase
How does CPU utilization and RAM utilization compare on the 2 servers?
Are the Sybase DB's indexed similarly? Could the procedure be doing a full table scan on one server and using an index on the other?
Is there a Sybase equivalent to Oracle's SGA? Is that set up similarly? Any other Sybase DB setups that could be different?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2009 11:48 AM
тАО04-22-2009 11:48 AM
Re: Performance problems with HP-UX 11.31 and Sybase
They are still investigating, but this procedure is called something like 4000 times an hour, and small improvements will make a lot of difference.
But, to answer your question in a general sense, the new server should have been much more powerful than the old. The old rp5470 has 10 GB of memory and three 750 MHz processors. The new rx2660 has 16 GB of memory and two 1.6 GHz processors.
The DBA's have been working with Sybase to resolve this issue, but there have been no table scans. We did run into that problem many years ago, and the symptoms are the same, just as you suggest.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-22-2009 11:51 AM
тАО04-22-2009 11:51 AM
Re: Performance problems with HP-UX 11.31 and Sybase
were the tests completed with nothing else running... did you compare CPU usage and IO using sar -Mu and sar -d
HTH
Duncan
I am an HPE Employee