- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Sybase performance
Operating System - HP-UX
1820590
Members
1833
Online
109626
Solutions
Forums
Categories
Company
Local Language
юдл
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Discussions
Forums
Forums
Discussions
юдл
back
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
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
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
- 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
- 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
- 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
- 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.
Company
Learn About
News and Events
Support
© Copyright 2025 Hewlett Packard Enterprise Development LP