|In some cases when it's neccessary to analyze the performance of a 2 tier application, extracting the required information from JDBC log files (execution time of procedures, reports, SQL staments count and average time, etc) may result more difficult than using a JMX monitor.
JMX can be used in win 2-Tier or batch aplications, in case you need to analyze these kind of information.
The "Perfomance" JMX Pack provides information on the SQL statements executed by the server.
In order to monitor a procedure (or any java program), you may execute the application in the following way, adding the corresponding system properties:
java -cp <classpath> -Dcom.sun.management.jmxremote.port=<port> -Dcom.sun.management.jmxremote.host=<host> <Java Package Name>.<ProcedureName>
java -cp gxclassr.zip;.;itext.jar;C:\Software\java\JDBC\jtds-1.2.jar -Dcom.sun.management.jmxremote.port=8899 aprocppal
Application Monitoring and Management