This article was written by Stevan Arychuk
From relational SQL databases like MySQL, Oracle, and Postgres to NoSQL data stores like Redis, Cassandra, and MongoDB, you have a lot of options to choose from when designing your application stack. Perhaps you’ve decided you need both MySQL and Redis in order to provide a good experience for your users. The flexibility is great, but using multiple components can make it difficult to understand the performance and operational impacts of each technology on your application.
We recently released an all new Databases Dashboard for New Relic APM designed to provide improved visibility to your application’s use of relational SQL and NoSQL databases as well as caches. This new dashboard provides more granular charts tracking the operations in each database and cache as well as a unified view of all databases and caches used by an application. This convenient view can allow you to quickly see the performance impact of a specific data store type on your application:
Overview Charts Now Show Performance of Individual Database/Cache Types
Once applications have been upgraded with agents that support the new dashboard, one of the first things you will notice is that the main chart on theOverview Dashboard can now show individual database types as separate bands, making it easy to see the performance impact of each database or cache on your application; clicking a band will take you to the new Database Dashboard filtered to that specific data store type.
Filter the Dashboard to a Specific Database/Cache Type
Finally, a unified dashboard for all SQL databases and NoSQL caches instrumented by our language agents! Even better is the ability to filter the page to show only operations, charts, and metrics for a specific data store type. By simply picking a specific type—‘memcached,’ for example—you can see a filtered page that shows only the metrics and charts for ‘memcached.’ This can be extremely helpful for developers trying to optimize the performance of their app, and for ops engineers who have to troubleshoot and support it.
See and Search All Database/Cache Operations
Taking a cue from our Transactions Dashboard, we have now included an ‘All Operations Table’ that is designed to show every operation for all databases and caches for the app within the selected time window. This new table also has filtering and sorting capabilities, contextual search, and includes the model when appropriate. You can find this link under the list of operations on the main dashboard page.
How to Get the New Hotness
The new Database Dashboard is available to all New Relic APM paid account types, and the updated Overview Page is available to all accounts. You will need to update your agents to a version that supports this feature, but it is supported by all New Relic agents: Java, .NET, PHP, Python, Ruby, and Node.js.