Tech Tip on Tracing database operations



In this blog we are going to give a Tech tip on tracing database operations using an Open source tool called P6SPY

We do see lot of performance bottlenecks in database operations. Tracing these botttlenecks is an important task in optimizing database operations. This information can help you fine tune the database calls that the application makes and in this way improve the application's performance. This Tech Tip from Jagadish will help demonstrate how to use a tool called P6SPY to trace the database requests issued by an application running with the GlassFish v2 application server. Here we learn how to trace SQL statements from an application that uses GlassFish's JDBC Connection Pool.



TAGS: glassfish tuning



Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Gopal Jorapur

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today