One of the most common questions we hear from customers is, “My application is running slowly; how do I use New Relic to pinpoint the cause?”
To use New Relic to troubleshoot a performance problem, follow these steps:
- Starting with an overview graph, such as Browser Page Load or Transaction Response Time, determine which element is taking the most time;
- Select the corresponding link or menu item to see more detail;
- Repeat as desired to drill down.
Let’s look at an example.
Step 1: Starting with an overview graph, determine which element is taking the most time
Imagine that one of your customers reports that your site is running slowly. You bring up the application’s dashboard in New Relic Browser.
According to the legend, the Browser Page Load Time graph displays times for Request queuing, Web application, Network, DOM processing, and Page rendering. Which of these elements is taking the most time (which item is largest on the graph)?
Step 2: Select the corresponding link or menu item to see more detail
To see more information about the Web application’s response time, click the App Server link above the Browser Response Time graph.
Step 3: Repeat as desired
On the application overview page, we see another graph, which brings us back to Step 1: Which element on this graph is taking the most time?
[click to enlarge][/caption][caption id="attachment_21484" align="aligncenter" width="660"]
[click to enlarge][/caption][caption id="attachment_21484" align="aligncenter" width="660"]It’s pretty clear that in this example, the home method of the PagesController is the most time-consuming. From here, you can look at a transaction trace or use New Relic’s thread profiler to drill down further and see what’s taking so long (Step 3).
A JDBC and Postgres example
What if a different element of the Transaction Response Time graph had been the largest?
In this example, JDBC and Postgres are the largest elements, indicating that most of the time is being spent in the data access layer. Select the Databases menu to see more detail.
The Databases dashboard shows that JDBC condition_alertables select is consuming the most time. From here, you can select individual queries to see where they’re being called, and the SQL code of the slowest queries.
A Web External example
One more example:
This time, Web External is the largest element, indicating that calls to out-of-process services are the culprit. Select the External Services menu to see more detail:
New Relic is designed to help make troubleshooting easier and to point you in the right direction with minimal effort. Just remember the three steps:
- Starting with an overview graph, such as Browser Page Load or Transaction Response Time, determine which element is taking the most time;
- Select the corresponding link or menu item to see more detail;
- Repeat as desired to drill down.
Consult these resources for more information:
The views expressed on this blog are those of the author and do not necessarily reflect the views of New Relic. Any solutions offered by the author are environment-specific and not part of the commercial solutions or support offered by New Relic. Please join us exclusively at the Explorers Hub (discuss.newrelic.com) for questions and support related to this blog post. This blog may contain links to content on third-party sites. By providing such links, New Relic does not adopt, guarantee, approve or endorse the information, views or products available on such sites.
