How can I monitor JPA database IO?

[CommunityUser]

We have a Java application, in which we use JPA to communicate with database. Now we saw some strange IO in database side, then would like to use this tool to analyze what is the database IO like and then based on the monitoring result, find the issues in source code.

I installed AppDynamics Pro, and ran the Java application with javaagent enabled, but I didn't see how to monitor database. How can I do that?

Thanks in advance!

Jake

[Arun_Dasetty]

Hi Jake,

Can you check whether database discovered under Servers -> Databases screen under the associated application:

which will shows calls per min, errors details,

http://docs.appdynamics.com/display/PRO13S/Monitor+Databases

Also can you confirm the the database details that you are trying to connect using jpa persistence transactions.

You can configure APPD4DB to additionally monitor database IO activity in detail:

http://docs.appdynamics.com/display/PRO13S/Integrate+with+AppDynamics+for+Databases

http://docs.appdynamics.com/display/ADDB/Install+and+Get+Started+with+AppDynamics+for+Databases

Let us know if that helps

Thanks,

Arun

[CommunityUser]

Hi Arun,

Thanks for your response.

We are using JPA transaction as the following configuration:

transaction-type="RESOURCE_LOCAL"

And I didn't see any database nodes under Server -> Databases node.

The links seem quite helpful, but where can I download AppDynamics for Databases installation package for Linux 64? I'm using AppDynamics Pro Trial, does it support the function of monitoring database?

Thanks,

Jake

[CommunityUser]

We will continue to look at why the JPA calls to your DB are not showing up as Database exit calls from the Java tier. 

Meanwhile, would like to let you know that our Database monitoring solution (which provide deep dive diagnostics for all the activity inside the database as opposed to just monitoring the exit calls from Java) is not included automatically in the self-service trial you are currently part of. If you want to trial the Database monitoring solution, then I suggest reaching our to your accout rep (he/she should have already initiated contact with you) and requesting trial access for the same. I will try to give the account rep an heads-up as well.

Let me know if you have further questions.

[CommunityUser]

Thanks. Please let us know when the trial version is available for us. We are interested in this tool, also could you let us know what the price of the AD4DB would be?

Jake

[Arun_Dasetty]

Hi Jake,

Can you please contact sales team requesting the details sales email id: "sales" <sales@appdynamics.com>,  regarding the pricing for APPD4DB

Thanks,

Arun

[CommunityUser]

Sure, I will query that after we could try this tool.

Thanks,
Jake

[Arun_Dasetty]

Hi Jake,

 Thanks for the update, in reference to your comment "transaction-type="RESOURCE_LOCAL" can you please provide the following details to debug further: Can you please attach the java class fiile or if possible the sample app you are trying (you can remove password and any security text if any) ,also provide the following details:

- database you are using to connect using jpa transactions

- database driver and version details

- persistence.xml config (related to jpa config)

this details will help us to simulate your test env in our local

Thanks,

Arun

-

[CommunityUser]

Yes, I could arrange a sample app if needed.

Is it possible to just monitor the database? We are using Amazon RDS, I saw two posts that mentioned this monitoring:

* http://java.dzone.com/articles/how-set-and-monitor-amazon-rds

* http://docs.appdynamics.com/display/PRO13S/Integrate+with+AppDynamics+for+Databases

How can we get the APPD4DB setup and configure with Amazon RDS?

Thanks,

Jake

[Arun_Dasetty]

Hi Jake,

We would like to inform that we could see that Amazon RDS is not listed under supported database backends list at:
 http://docs.appdynamics.com/display/PRO13S/Supported+Environments+and+Versions#SupportedEnvironments...
 and actually this docs is meant for steps to configure appd4db in controller UI at
 http://docs.appdynamics.com/display/PRO13S/Integrate+with+AppDynamics+for+Databases and also we see from attached screenshot,
 the supported database by appd4db are db2, mysql, mssql, sybase, oracle and postgress, let us know if any disconnect


 However we can try if your amazon RDS database driver have classes that implements java.sql.Connection , java.sql.Statement, java.sql.PreparedStatement etc
 adding the following properties at node level -> app agent config screen from controller UI:
 jdbc-callable-statements, jdbc-connections, jdbc-prepared-statements, jdbc-statements
 refer docs: http://docs.appdynamics.com/display/PRO13S/App+Agent+Node+Properties+Reference#AppAgentNodePropertie...
 http://docs.appdynamics.com/display/PRO13S/App+Agent+Node+Properties+Reference#AppAgentNodePropertie...
 Please keep us posted the sample app, database driver you are using and the other jpa config files requested earlier to debug further,
 
 we are glad to assist and will try the above properties to check if that helps
 
Thanks,

Arun

[CommunityUser]

Thank you Arun for the following up.

Our application structure is simple - we are using JPA (with Hibernate) to access MySQL database provided by Amazon RDS. So I think you could create a hello world application using this structure quickly.

I tried another tool mysql-proxy, which resolved our problems. Anyway, I'm still interested in how it can be done in APPD4DB.

Thanks,

Jake

[Arun_Dasetty]

Hi Jake,

Thanks for the update, Great to hear that mysql-proxy had solved the problem. For integrating and monitoring your mysql using APPD4DB you can try adding agent and select type mysql in agent config screen, refer docs:

http://docs.appdynamics.com/display/ADDB/Install+and+Get+Started+with+AppDynamics+for+Databases let us know if that helps.

Sure we can give try the sample app, however as it takes time to simulate the case in local, it would be great if you provide your test sample which will help us to speed up the process

Thanks,

Arun

[CommunityUser]

This goes back to my initial question: where can I download "AppDynamics for Databases"? Also I don't have a sample app on hand for now, the current running code is in a big repository.

Anyway, my problem is resolved, thank you for the communication. I will keep an eye on AppDynamics for Databases.

Thanks,

Jake

[Arun_Dasetty]

Hi Jake,

Thanks for the update, As i said earlier you can send information on how to buy DB Monitoring tool by sending the request email to "sales" <sales@appdynamics.com>,

Thanks,

Arun

[CommunityUser]

Hi,

In Amazon RDS ( http://aws.amazon.com/rds ) actually we are using MySQL.

Thanks,

Jake

[Arun_Dasetty · Accepted solution]

Hi Jake,

Thanks for the update and clarifying the database details, please provide the sample app and persistence config so that we will give a try in local in addition to the zipped version of agent logs requested.

we see that amazon rds is a web service, can you confirm whether websservice stack it uses and also can you confirm whether ws entry point is enabled , please provide the requested details earlier to debug further

Thanks,

Arun

http://69.27.44.55/controller/