Ed Ort

Enterprise Tech Tip: Using P6Spy and the GlassFish Connection Pool to Trace Database Operations

Detecting performance bottlenecks is an important task in optimizing database operations in an application. One way to do that is to trace the database operations of the application. This information can help you fine tune the database calls that the application makes and in this way improve the application's performance. In this Tech Tip, Sun engineer Jagadish Ramu demonstrates how to use a tool called P6Spy to trace the database requests issued by an application running with the GlassFish v2 application server. Specifically, you'll learn how to trace SQL statements from an application that uses GlassFish's JDBC Connection Pool. It's all covered in the tip Using P6Spy and the GlassFish Connection Pool to Trace Database Operations.

Posted at 09:46AM Jul 15, 2008 by edort in Tech Tip  |  Comments[0]