Skip to ContentSkip to Footer
Start of content
- Community Home
- >
- Servers and Operating Systems
- >
- Operating System - HP-UX
- >
- General
- >
- Sybase performance
General
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
-
- Forums
-
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
- HPE Blog, Austria, Germany & Switzerland
- Blog HPE, France
- HPE Blog, Italy
- HPE Blog, Japan
- HPE Blog, Middle East
- HPE Blog, Russia
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
-
Blogs
- Advancing Life & Work
- Advantage EX
- Alliances
- Around the Storage Block
- HPE Blog, Latin America
- HPE Blog, Middle East
- HPE Blog, Saudi Arabia
- HPE Blog, South Africa
- HPE Blog, UK & Ireland
- HPE Ezmeral: Uncut
- OEM Solutions
- Servers & Systems: The Right Compute
- Tech Insights
- The Cloud Experience Everywhere
-
Information
- Community
- Welcome
- Getting Started
- FAQ
- Ranking Overview
- Rules of Participation
- Tips and Tricks
- Resources
- Announcements
- Email us
- Feedback
- Information Libraries
- Integrated Systems
- Networking
- Servers
- Storage
- Other HPE Sites
- Support Center
- Aruba Airheads Community
- Enterprise.nxt
- HPE Dev Community
- Cloud28+ Community
- Marketplace
-
Forums
-
Blogs
-
Information
-
English
Topic Options
- 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
- Email to a Friend
- Report Inappropriate Content
07-26-2002 10:47 AM
07-26-2002 10:47 AM
Sybase performance
I have a sybase dataserver process that runs high cpu with a wait state on PRI. Attached is a glance snapshot. Freshly installed 11.00 O/S with current patches applied. The DBA's are trying to a large table. Any clues?
- Tags:
- Sybase
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-26-2002 11:09 AM
07-26-2002 11:09 AM
Re: Sybase performance
Has the database been tuned? Has the table been indexed? Look at your cache hit ratios. They should be in the high 90s.
HTH
Marty
HTH
Marty
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-26-2002 05:46 PM
07-26-2002 05:46 PM
Re: Sybase performance
Ken:
It has been a long time since I have dealt with Sybase, but...welcome to Sybase. There is a reason you configure N-1 dataservers (where N is the number of CPUs). Each dataserver process will consume a CPU, even when the database is "quiet". Maybe someone will tell us that this is antiquated knowledge.
-dlt-
It has been a long time since I have dealt with Sybase, but...welcome to Sybase. There is a reason you configure N-1 dataservers (where N is the number of CPUs). Each dataserver process will consume a CPU, even when the database is "quiet". Maybe someone will tell us that this is antiquated knowledge.
-dlt-
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-30-2002 03:03 AM
07-30-2002 03:03 AM
Re: Sybase performance
Does the machine run other applikations also? It seems that you have more CPUs availible that you might consider to run Sybase on. The parameter "Online engines" states how many processes it should run. Inside Sybase, sp_sysmon shows how Sybase thinks of its performance.
Regards
Johan
Regards
Johan
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
End of content
United States
Hewlett Packard Enterprise International
Communities
- Communities
- HPE Blogs and Forum
© Copyright 2021 Hewlett Packard Enterprise Development LP