• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

DB Monitoring

 
Ranch Hand
Posts: 48
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Any Takers???
 
author & internet detective
Posts: 41860
908
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Ranch Hand
Posts: 862
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Whose rules are you playing by? This tiny ad doesn't respect those rules:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic