- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- What to monitor for 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-27-2004 06:06 PM
тАО04-27-2004 06:06 PM
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-27-2004 07:40 PM
тАО04-27-2004 07:40 PM
Re: What to monitor for Sybase?
i m not a Sybase admin. but why not to use the DBSPI of the ovo to do it ?
the DBSPI it a software ( that you need to buy ) that is doing all the work that you are talking about , i thing that it is much easeir to do then to try to monitor the Sybase with template that you will write .
you can also monitor any database that you want ( like oracle , SQL and others )
go to www.openview.hp.com to see more info
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2004 04:17 AM
тАО04-29-2004 04:17 AM
Solution# ps -fu $SYBASE_DBA |grep "/opt/sybase/*/dataserver -s $INSTANCE"
where $SYBASE_DBA is the DBA username and $INSTANCE is the instance name.
P.S: You need at least two dataserver proc per instance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2004 04:54 AM
тАО04-29-2004 04:54 AM
Re: What to monitor for Sybase?
I am not sure if your question is directed on finding out what softwares are available for monitoring Sybase or if what components of the Sybase environment can be monitored. I shall briefly touch on both and you let us know if any additional information is required
1. S/W Available for Monitoring Sybase
--------------------------------------
We have been using BMC Patrol for Sybase and it works wonderfully well. This monitoring tool goes into depth and provides you with lot of flexibility in setting up your monitoring environment. In fact you can even set some actions to be performed when an event if triggered.
If you are looking at some low level of monitoring without having to spend any $$, then Sybase's own tool SQL Advantage or Sybase Central (i don't remember which one) should be able to do that.
2. What can be monitored in a Sybase ASE
----------------------------------------
Some of the components like the following can be monitored in Sybase
a. The log thresholds
b. /DUMP file system
c. DBVolume growth
d. DB going into log suspend mode
e. Monitor for any known/predefined errors
in the sybase error log
f. No. of connections
g. No. of locks (many of the sp_configure)
parameters and
h. Infact you can monitor almost everything
Let me know if you have any specific questions
regards
Mobeen
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО04-29-2004 11:47 AM
тАО04-29-2004 11:47 AM
Re: What to monitor for Sybase?
Anyway, I will first start the monitoring with the "dataserver" process & the sybase error logfile. The monitoring items suggested by Mobeen are useful to me, but it will take much time to develop the monitoring script required.
Many thanks