Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

New APM Database Dashboard for SQL and NoSQL Databases and Caches

DZone's Guide to

New APM Database Dashboard for SQL and NoSQL Databases and Caches

The new APM Database Dashboard offers better visibility for SQL and NoSQL databases and caches thanks to overview charts and a new host of cache operations.

· Database Zone
Free Resource

Whether you work in SQL Server Management Studio or Visual Studio, Redgate tools integrate with your existing infrastructure, enabling you to align DevOps for your applications with DevOps for your SQL Server databases. Discover true Database DevOps, brought to you in partnership with Redgate.

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:

screen-databases-overview-0215

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.

Screen Shot 2015-03-10 at 4.12.02 PM

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.

Screen Shot 2015-03-10 at 3.00.25 PM

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.

Screen Shot 2015-03-10 at 2.48.14 PM

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.



It’s easier than you think to extend DevOps practices to SQL Server with Redgate tools. Discover how to introduce true Database DevOps, brought to you in partnership with Redgate

Topics:
news ,sql ,nosql ,high-perf ,database ,performance ,new relic ,apm

Published at DZone with permission of Fredric Paul, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}