Introducing the Scout database monitoring addon

November 04 Bullet_white By Derek Bullet_white Comments Comments

Perhaps the most significant performance problem spot in web apps is the database. In apps monitored by Scout, database queries account for nearly a third of the time spent in the average Rails web request. Just as important, the more time an app spends in the database, the more volatile its response times. Here's a breakdown:

Service Layer % of Response Time Correlation to Response Time Volatility
Database 32%
0.35
Ruby 24%
0.23
HTTP calls 9%
0.06

Data is based on apps monitored by Scout averaging 50 requests per-minute or higher.
The response time correlation measures the ratio of an app's 95th response time duration to the mean response time. This value may range from -1 to 1.

Database queries deserve some extra performance love, and our database monitoring addon is here to help.

A tour of database monitoring

When the database monitoring addon is enabled, you'll gain access to two additional areas of Scout. These are described in detail within our docs. In the short video below, I show the addon in action as I debug a real-life database problem:

Installation

Just update - or install - the scout_apm gem in your application. There's no special libraries to install on your database servers.

Pricing

Database monitoring is available as an addon. More information is available on the billing page of your account.

New to Scout? Try out database monitoring in our credit card-free 14-day trial.

Get notified of new posts.

Once a month, we'll deliver a finely-curated selection of optimization tips to your inbox.

Comments

comments powered by Disqus