This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes JDBC and the fly likes DB Monitoring Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DB Monitoring" Watch "DB Monitoring" New topic
Author

DB Monitoring

Karthik Prabu
Ranch Hand

Joined: Dec 27, 2002
Posts: 48
Hi Folks,

I need to write a Monitoring tool for Sybase 12.0 DB using JDBC. Can u please suggest what all parameters to be monitored? For example number of locks etc..

Thanks
Saravanaan. A
Karthik Prabu
Ranch Hand

Joined: Dec 27, 2002
Posts: 48
Any Takers???
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30789
    
157

Google has some ideas. The performance monitoring software documentation also has a good list.
[ September 24, 2004: Message edited by: Jeanne Boyarsky ]

[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
steve souza
Ranch Hand

Joined: Jun 26, 2002
Posts: 861
Before going to far I would make myself familiar with what Sybase already offers. They offer monitor server, and historical server (which I believe saves monitor servers data), and if you can upgrade Sybase 12.5 has built-in monitoring tables called MDA tables.

The following site has info on the MDA tables and is a great general Sybase reference site too

http://www.sypron.nl/mda.html


http://www.jamonapi.com/ - a fast, free open source performance tuning api.
JavaRanch Performance FAQ
steve souza
Ranch Hand

Joined: Jun 26, 2002
Posts: 861
I should also mention that I use a DataAccess class that does all my jdbc and I make calls in it to JAMon to monitor all my jdbc. One advantage of this approach is that it will monitor any database not just Sybase. This is viewable in an html report.

To see the report and a live demo that generates jdbc stats use this link:
http://ssouza.kgbinternet.com/fdsapi/JAMonAdmin.jsp

To see the DataAccess wrapper code see this one:
http://fdsapi.sourceforge.net/javadocs/com/fdsapi/DataAccessBase.html
 
Consider Paul's rocket mass heater.
 
subject: DB Monitoring