Tuesday, September 1, 2009

P6Spy Open Source Framework to detect database performance bottlenecks in Java applications

What is P6Spy?
P6Spy is an open source framework for applications that intercept and optionally modify database statements. The P6Spy distribution includes the following modules:
  1. P6Log. P6Log intercepts and logs the database statements of any application that uses JDBC. This application is particularly useful for developers to monitor the SQL statements produced by EJB servers, enabling the developer to write code that achieves maximum efficiency on the server. P6Spy is designed to be installed in minutes and requires no code changes.
  2. P6Outage. P6Outage detects long-running statements that may be indicative of a database outage proble and will log any statement that surpasses the configurable time boundary during its execution. P6Outage was designed to minimize any logging performance penalty by logging only long running statements.
P6Spy includes installation instructions for JBoss, ATG, Orion, JOnAS, iPlanet, WebLogic, WebSphere, Resin and Tomcat.
What if you want it inside your favorite Eclipse IDE?
Don't worry there is an eclipse plugin for you here.
Posted by at
Labels: , , ,

6 comments:

  1. Artur BiesiadowskiSeptember 2, 2009 at 6:13 AM

    Why P6spy? Is it still developed? Last time I have checked it, there were no news for few years.

    I think that log4jdbc is 'new p6spy'
    http://code.google.com/p/log4jdbc/

    ReplyDelete
  2. Ananth ChelladuraiSeptember 2, 2009 at 9:12 PM

    Hey Artur,
    Thanks for that link. I agree that P6Spy is not active for a while. The reason I choose it because I couldn't find any better open source tools. Does Log4jdbc has options to log only long running statements?
    Ananth Chellathurai

    ReplyDelete
  3. ChrisSeptember 4, 2009 at 11:41 AM

    Hi,

    I am interested in advertising on your site. I think its awesome!

    Please get back to me when you have a chance.

    crose@enticelabs.com

    Thanks

    ReplyDelete
  4. UnknownJune 16, 2010 at 5:31 AM

    Business networks, such as LinkedIn, ZoomInfo, etc., can be a very helpful way to find professionals that may fit into your software development or management teams. LinkedIn has data that is entered by the individual, whereas ZoomInfo assembles data by scouring the 'net.

    ReplyDelete
  5. protein powderJune 18, 2010 at 3:19 AM

    With Office Project Standard 2007, you can easily assign resources to tasks and adjust their assignments to resolve conflicts over allocations. Control finances by assigning budgets to projects and programs.

    ReplyDelete
  6. JensiaJanuary 10, 2018 at 8:10 PM

    I'm very enjoyed with this blog. Its an informative topic. It help me very much to resolve some problems. Its opportunity are very fantastic and working style so speedy. ecommerce platforms

    ReplyDelete

Subscribe to: Post Comments (Atom)