In many organizations, database ownership lies with a central infrastructure or dedicated DBA team, separate from the application development effort. While application performance monitoring (APM) provides valuable insights, these central teams need the ability to instrument and visualize database load and performance directly, without relying on APM agents. They need to see not just that a database is slow, but precisely why it's slow, with query-level detail.
Today, we’re excited to announce the General Availability of enhanced Database Performance Monitoring in New Relic. With this launch, you can now capture deep query-level details directly from your database instances.
This enhancement to our On-Host Integration (OHI) gives you detailed visibility into slow queries, grouped query details, database wait types, and query execution plans for your MySQL, Microsoft SQL Server, and PostgreSQL databases. It empowers DBA and infrastructure owners to find and fix performance bottlenecks faster, improving the reliability and performance of the services that depend on them.
Go beyond APM for a complete database view
For a dedicated DBA, understanding database performance shouldn't require access to application code or agents. The core problem is that a database is a shared resource, and the team that manages it needs a toolset focused on its specific performance characteristics. Our enhanced OHI provides those query-level insights directly from the database instrumentation, giving DBAs the autonomy and data they need to ensure performance and reliability for all the applications that consume their service.
Pinpoint bottlenecks with wait types and explain plans
When an application is slow, the root cause is often an inefficient query. To solve this, you need more than just metrics; you need to understand exactly why a query is performing poorly. We now scrape detailed information including wait types and the actual query execution plans. This means you can move from identifying a slow query to understanding its specific waits and analyzing its execution plan, dramatically reducing the time it takes to diagnose and resolve the issue.
Simplify monitoring across your hybrid estate
Your database infrastructure likely spans on-premise servers and cloud environments. This new functionality supports self-hosted MySQL, PostgreSQL, and Microsoft SQL Server databases and also includes AWS Aurora/RDS compatibility. This allows you to standardize your deep database monitoring on New Relic across your entire hybrid estate.
Getting started is designed to be a straightforward, practitioner-oriented experience.
- Navigate to the guided install process under Integrations & Agents in New Relic One.
- Select your database type (MySQL, PostgreSQL, or Microsoft SQL Server).
- Follow the step-by-step guide to deploy the On-Host Integration (OHI) into your environment where your database is hosted. The process can be done manually or automated with the New Relic CLI.
- Once the instrumentation is installed and sending data, you can view the detailed performance data on single-entity pages or multi-entity dashboards.
More Information
For more detailed installation instructions and further information on specific database types, please refer to the New Relic documentation:- Microsoft SQL Server: Install Microsoft SQL Server
- MySQL: Install MySQL
- PostgreSQL: Install PostgreSQL
다음 단계
- Read the docs to get detailed instructions for installing and configuring the On-Host Integration for your specific database.
- Sign up for New Relic. Your free account includes 100 GB/month of free data ingest, one free full-access user, and unlimited free basic users. All data from this integration is charged as paid ingest.
이 블로그에 표현된 견해는 저자의 견해이며 반드시 New Relic의 견해를 반영하는 것은 아닙니다. 저자가 제공하는 모든 솔루션은 환경에 따라 다르며 New Relic에서 제공하는 상용 솔루션이나 지원의 일부가 아닙니다. 이 블로그 게시물과 관련된 질문 및 지원이 필요한 경우 Explorers Hub(discuss.newrelic.com)에서만 참여하십시오. 이 블로그에는 타사 사이트의 콘텐츠에 대한 링크가 포함될 수 있습니다. 이러한 링크를 제공함으로써 New Relic은 해당 사이트에서 사용할 수 있는 정보, 보기 또는 제품을 채택, 보증, 승인 또는 보증하지 않습니다.
