DB connections from NRQL

Is there any way to get transaction details which utilized the highest no. of DB connections from NRQL?? A consolidated view for optimization candidates

Hi there @himanshu.jain -

This is an interesting question! Welcome back to the community and thanks for asking this!

To get you an answer, I need to clarify. Are you looking to understand which applications (APM) are making the most database calls? If so - which language agents are you using?

Hi, @himanshu.jain: You may use the following query to see the number of database queries by transaction:

SELECT sum(databaseCallCount) 
FROM Transaction
FACET appName, name

New Relic APM does not track database connections.

1 Like

Java Agent is agent used

Thanks @himanshu.jain -

As @philweber mentioned, we can’t query for the connections the database makes to the agent, but we can track the number of calls. Let us know if Phil’s query gets you close to what you need.