Healthcare IT, Our Tech, Testing

Improving Database and Web Performance with New Relic – First Impressions

We’re always trying new ways to monitor our service uptime and performance.  It’s business critical that users on our website have a smooth and fast experience, particularly as most of our visitors are using mobile devices.

We have heard a lot of good stories about New Relic, which gives real-time insight and metrics to how your application is performing, after seeing they offer a free trial our tech team was excited to try out this shiny new toy.

We’ve only just got it installed, set up and running but first impressions?  Very impressive.  We knew a couple of our stored procedures were slow and giving problems, but which ones exactly?  How long do they take?  How often are they run?  What does this mean to different users viewing different pages?  Where should we focus our effort?  New Relic quickly pointed us in the right direction and gave detailed metrics on what was happening.

So what did we do with this information?  Optimise the problems that have the highest impact, of course.  The graphs below show the web page and database response in our most painful spot.  It is a measure of time so the more area in the graph, the worse it is performing.  The line on the graph is added by New Relic automatically when you deploy code – a useful feature which allows you to compare performance before and after a change.

New Relic - Web Transaction TimeNew Relic - Database Response Time

The result is pretty impressive, not just that we managed to fix our biggest problem, but that we can see instantly with real data the effect that it has for end users.  Score one for New Relic.  Now, what else can it do…