JDbMonitor and P6Spy
Today, as announced early today on The Server Side, JDbMonitor version 1.0 has been released. This particular product looked familiar, and after doing some digging around, it appears to be very similar to a very useful product that hasn't seen any recent development, P6Spy.We've used P6Spy over the last two years to sit in between our web applications and our databases to see which SQL commands are run the most often. It also will allow you to see how long PreparedStatement's take, and other very interesting statistics. Unfortunately, P6Spy is no longer supported, and the News on the main website was last updated in 2005. We've had some issues with certain types of preparedStatements inside of Informix, and also in using the software within Tomcat with DataBase Connection Pooling.
JDbMonitor looks like the new player on the block, and if they perform as well as P6Spy did, then they should see some decent success. Users of MySQL and PostgreSQL could probably use this type of utility, as well as Informix (which is what we usually run P6Spy on). EnterpriseDB has a built-in tool, called DBA Manager, which is a similar utility for PostgreSQL (native, rather than a Java utility).
0 Comments:
Post a Comment
<< Home