- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: help! 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
тАО12-15-2005 09:00 PM
тАО12-15-2005 09:00 PM
Re: help! performance issue
I'm pretty sure that your issue is bad SQL code in those views so this is where your battle must be fighting!
Yesterday for example I had a little code executing for more than 3 minutes to get 1 record. I've changed the logic and now it runs in 1 or 2 seconds...
First of all, in your Production environment, execute directly the SQL code of one of those views WITHOUT SORTING and post here your feedback about performance: if it is much better then the sorts are your problem. Check why most sorts are simply wasting resources in this thread:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=979701
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-16-2005 01:52 AM
тАО12-16-2005 01:52 AM
Re: help! performance issue
You mention lots of disk sorts - how large is your sort_area_size, and do you have enough memory to increase it?
You may never be able to explain why it got worse, but looking at the execution plan of some of the top queries may help you to correct them.
If TEMP is on one disk - is it possible to spread it to more disks?
Patti
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-16-2005 04:38 AM
тАО12-16-2005 04:38 AM
Re: help! performance issue
A couple thoughts. It might take awhile for the excution plans an cache to get set.
Might consider building the indexes in a different tables space/disk location. Or check to make sure that you rebuid the index in their orginal location.
Rory
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-16-2005 07:45 AM
тАО12-16-2005 07:45 AM
Re: help! performance issue
no Information to really work on.
Could you attach at least the view definition (CREATE VIEW ...) if no EXPLAIN for the access plan is currently available ?
Best regards
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-21-2005 01:49 AM
тАО12-21-2005 01:49 AM
Re: help! performance issue
- « Previous
-
- 1
- 2
- Next »