Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

DB Monitoring

 
Karthik Prabu
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 48
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Any Takers???
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34071
331
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Google has some ideas. The performance monitoring software documentation also has a good list.
[ September 24, 2004: Message edited by: Jeanne Boyarsky ]
 
steve souza
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
steve souza
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic