High response time of Get Pooled Connection From Datasource

[CommunityUser]

Hi,

I am new to app dynamics and need your help.

I had executed a test and on drill down I observed  high response time for "Get Pooled Connection From Datasource".

Can someone please help me to know what is "Get Pooled Connection From Datasource" and what could be the possible reasons for high response time for connection from datasource?

Thanks in advance.

Regards,

Adil

[Arun_Dasetty]

Hi Adil,

It could be due to following reasons, check if that information helps:

- We see such high response times for retrieving/creating connection from connection pool take more time if pool size is too small and there are no open connection available. Increasing pool size should help here.

- Check if JVM heap usage and CPU is not overloaded during the problem period during Major GC or lack of resources at system level , check GC and CPU data under Node dashboard -> Memory and Hardware tabs,

Can you please check the whether this is the case under Analyze -> Metric browser -> Application infrastructure performance -> JMX -> JDBC connection pool -> select target connection pool name/datasource in controller UI Or you can check the same using JMX Mbean browser from Node dashboard -> JMX -> Mbean browser -> expand the target connection pool mbean to check current pool size mbean metric value.

refer docs: http://docs.appdynamics.com/display/PRO39/Monitor+JMX+MBeans

Regards,

Arun

[CommunityUser]

Thanks for your response.

I have checked, during that period CPU utilization of DB was nearly 100%.

Does this error has any relation with CPU utilization of DB?

pleae advise.

[Arun_Dasetty]

Hi Adil,

Given that there are no CPU performance issues and High GC issues on the JVM instance machine but found CPU performance issues at DB instance , if this is the case, we confirm it could happen that connection requested by JVM is not allocated by DB engine due to CPU/performance issue at the DB instance and that could be the root cause here, Hope that answers your query.

Regards,

Arun

[CommunityUser]

Thanks alot Arun.

Is there any way in App Dynamics to check the run queue length of DB CPU?

Thanks,

Adil