Pooled Connections taking long time

[CommunityUser]

Some times in my Production Env , i see my Few issues which getting a Data Source Connection.

Is there any Way to find about the reason for that.

Iam attaching a Screen shot on the Request Snap shot.

Please let me know if there are any ways to find the exact reason?

[Arun_Dasetty]

Hi Jagadesh,

Please find few ways to debug further the slow database connection :

- select "partial call graph" tab in the screenshot you have provided and you should see the call stack that invokes the JDBC connect pool, so that you can debug in code level the method that creates connection

- increasing connection pool at datasource level

- you can take thread dumps from node dashboard -> agents -> request agent logs -> select thread dumps option,
to check if any threads are blocked

- you can install appdynamics database monitoring tool which provides more performance related information

http://www.appdynamics.com/solutions/database-monitoring

Thanks,

Arun

[CommunityUser]

I Will Work on This.

This Seems to help me.

I will update with more Data.

Thanks 

Kumar