Skip to technology filters Skip to main content
Dynatrace Hub

Extend the platform,
empower your team.

Popular searches:
Home hero bg
DatabasesDatabases
Databases

Databases

Easily monitor, troubleshoot, and optimize your entire database fleets.

App
Try in PlaygroundDocumentation
DBAs can see environment dynamics i.e. monitored databases, database hosts and other useful resources.DBAs have access to all DB performance statistics.DBAs can analyze the performance of long-running statements over time and request for execution plans.DBAs can quickly configure DB monitoring extensions directly in an application​.
  • Product information
  • Release notes

Overview

The Databases app provides a unified view over all elements necessary for unified observability, including services, hosts, instances, and other core elements that can influence database performance, such as tablespaces, or Oracle multi-tenant entities (like container databases, pluggable databases, and others).

This app aims to be the only tool required to monitor and understand the availability and performance impact of all observed databases for all stakeholders involved.

Use cases

  • Simplify database monitoring with a comprehensive, unified view of database usage, reducing reliance on vendor-specific tools.
  • Share the same perspective with all users using a single tool without the need for vendor-specific database management tools.
  • Track the performance and availability of all databases in a unified way.
  • Monitor the performance of the most expensive database statements.

Coming soon

  • Database administrators (DBAs) can analyze query plans to optimize a statement's performance.
  • App owners can efficiently manage databases through a detailed server-level view, enabling quicker problem resolution and fostering collaboration with DBAs.

Get started

  1. The application is pre-installed in your environment.
  2. Use the App Launcher to run the application.
  3. Configure database monitoring extensions using the Expand monitoring option.

Details

This application is a brief introduction of a planned end-to-end observability and intelligent tracing for databases application. Please share your feedback about the application via a dedicated Dynatrace feedback channel or by raising a product idea.

Attention

Query performance tracking may expose sensitive data in reported statements. Consequently, Dynatrace provides an optional mechanism that allows masking of selected attributes. Details are available in Dynatrace Documentation.

The configurations below shows you how to hide data, specifically for the purpose of query performance tracking.

The first option is to create a processing rule under Settings -> Log Monitoring -> Processing by filling Processor definition e.g. USING(INOUT content) | FIELDS_ADD(content: REPLACE_PATTERN(content, "(\"'\"):p1 (LD):p2 (\"'\"):p3", "${p1}${p2|sha1}${p3}")) .

Masking in settings

The same can be achieved by extension modification, which involves additional logProcessingRules section.

logProcessingRules:
  - ruleName: TopN statements masking
    query: event.group="query_performance"
    enabled: true
    ProcessorDefinition:
      rule: |
        USING(INOUT content) | FIELDS_ADD(content: REPLACE_PATTERN(content, "(\"'\"):p1 (LD):p2 (\"'\"):p3", "${p1}${p2|sha1}${p3}"))
    RuleTesting:
      sampleLog: |
        {
          "event.group": "query_performance",
          "content": "/*dt:ownQuery*/SELECT DECODE(name, 'sessions', value) AS sessions_limit, DECODE(name, 'processes', value) AS processes_limit FROM v$parameter WHERE name IN('sessions', 'processes')"
        }

Please adjust the above rule to match your environment, if needed.

Dynatrace
Documentation
By Dynatrace
Dynatrace support center
Subscribe to new releases
Copy to clipboard

Related to Databases

Oracle Database logo

Oracle Database

Observe, analyze and optimize the usage, health and performance of your database

Microsoft SQL Server logo

Microsoft SQL Server

Improve the health and performance monitoring of your Microsoft SQL Servers.

SAP HANA Database (remote monitoring) logo

SAP HANA Database (remote monitoring)

Easily understand the health and performance of your SAP HANA databases.

PostgreSQL logo

PostgreSQL

Monitor your Postgres performance via our new EF2.0 extension framework.

Microsoft SQL Server (local) logo

Microsoft SQL Server (local)

Improve the health and performance monitoring of your Microsoft SQL Servers.

IBM DB2 for LUW (remote monitoring) logo

IBM DB2 for LUW (remote monitoring)

Remotely collect monitoring metrics from your DB2 databases.

More resources

Dynatrace launches Databases app to provide DBA insights across all databases

Dynatrace launches Databases app to provide DBA insights across all databases

Explore Dynatrace's new Observability app, Databases. It supports DBAs in tracking database performance, assessing availability, and enabling efficient troubleshooting with its architecture insight feature.
Blog Post

Full version history

ReleaseDate

Full version history

1.46.5

Patch Changes

  • Fixes an issue with host related timeseries lookups
  • Fixed Execution Plan request button, when Statement Performance table is sorted or row is expanded.

Full version history

1.46.4

Patch Changes

  • Fixes an issue in logs card on top queries tab.

Full version history

1.46.3

Patch Changes

  • Fixes statement performance tab on Safari browser.
  • Fixes application crashes that occur when PostgreSQL and Snowflake extensions are enabled but no database instances are monitored.

1.46.2

Patch Changes

  • Adds user-friendly error messages related to missing host relation fields for database instances.
  • Improves explorer view when no records are shown.
  • Fixes highlighting in header tabs.
  • Fixes lazy loading of metrics in "Utilization" perspective of databases table.

1.46.1

  • Brings more app stability improvements.

1.46.0

Minor Changes

  • Adds an option to create a workflow to auto-fetch execution plans through the 3-dot menu option in the "Statement Performance" tab in the entity details panel.
  • Adds summary charts above the entities table on the Explorer page.
  • Adds a host perspective for the entities table.

Patch Changes

  • Adds a click action for the problems chip in the entities table that will open the "Problems" tab in the entity details panel.
  • Adds trimming for statements longer than 255 characters in the "Statement Performance" tab in the entity details panel and a button to show the full content of the trimmed statement.
  • Adds "Open with..." and "Pin to Dashboard..." actions to the 3-dot menu in the "Statement Performance" tab in the entity details panel.
  • Fixes the OA status of instances where OA was uninstalled.
  • Fixes the error with PostgreSQL and Snowflake statuses that resulted in an app crash.

Full version history

1.46.1

  • Brings more app stability improvements.

1.46.0

Minor Changes

  • Adds an option to create a workflow to auto-fetch execution plans through the 3-dot menu option in the "Statement Performance" tab in the entity details panel.
  • Adds summary charts above the entities table on the Explorer page.
  • Adds a host perspective for the entities table.

Patch Changes

  • Adds a click action for the problems chip in the entities table that will open the "Problems" tab in the entity details panel.
  • Adds trimming for statements longer than 255 characters in the "Statement Performance" tab in the entity details panel and a button to show the full content of the trimmed statement.
  • Adds "Open with..." and "Pin to Dashboard..." actions to the 3-dot menu in the "Statement Performance" tab in the entity details panel.
  • Fixes the OA status of instances where OA was uninstalled.
  • Fixes the error with PostgreSQL and Snowflake statuses that resulted in an app crash.

Full version history

1.45.2

  • App loads properly now when only Snowflake or PostgresSQL are configured.

1.45.1

  • Updates the UI to unify user experience with other Dynatrace apps.<br> The new overview and explorer pages provide more structured data that is easily accessible.
  • Unifies statuses between different database services. <br> Click on the status chip to see the current status reported by the service.
  • Adds "Summarize with Davis CoPilot" button to explain the execution plan in statements explorer.
  • Adds the OneAgent status bar to the details view.
  • Improves UX of execution plan request in statements explorer.

Full version history

1.45.1

  • Updates the UI to unify user experience with other Dynatrace apps.<br> The new overview and explorer pages provide more structured data that is easily accessible.
  • Unifies statuses between different database services. <br> Click on the status chip to see the current status reported by the service.
  • Adds the OneAgent status bar to the details view.
  • Improves UX of execution plan request in statements explorer.

Full version history

1.44.0

  • Add built-in dashboard which you can check in the Dashboards app.
  • Fix table flickering on every interaction on the page.
  • Update chart colors on entity details panel to be more balanced.
  • Add better text formatting for execution plans that are in XML format.
  • Hide queries that have '/*dt:ownQuery*/' comment in the beggining and give option to show them back through the options menu on the 'Statement performance' panel.
  • Update help menu in the app header section to unify the UX between different apps.

Full version history

1.43.0

  • Fix Oracle RAC
  • Minor improvements

Full version history

1.42.0

  • Fix detection of Statement Performance availability
  • Fix navigation from Overview page to statement details on Statement Performance page

Full version history

1.41.0

  • Enable new look of TopN's by default

Full version history

1.39.0

  • On demand execution plans for most time-consuming statements

Full version history

1.38.0

  • Minor improvements

Full version history

1.33.0

  • Changing the Snowflake icon
  • Minor improvements

Full version history

1.30.0

Patch Changes

  • Changing release notes mechanism
  • Changing the mechanism of loading metrics/statuses on Database instances page
  • Updating help menu options

Full version history

  • database.identifier added
  • adjusting changes to EXT-8984
  • execution plan request modification

Full version history

  • Disable E2E tests (temporary)
  • updated README.md file
  • Remove storybook
  • prepare env and first test manual test
  • change feedback link

Full version history

  • hotfix feedback link
  • fix language configuration for DB app

Full version history

  • fix time formatting
  • Add help button to Databases app
  • Make DQL queries non-billable
  • filter on instances page doesn t reset after refresh
  • need to have default sort by problems count

Full version history

  • fix most consuming statements and topN requests sequence
  • DatabasesNew icon change into purple one
  • Update unified-analysis to 0.10.0
  • Add metrics preprocessing, restore memory consumption for MSSQL.
  • remove memory consumption for MSSQL vendor
  • dependency update
  • modify the look of left menu bar
  • menu bar modifications part1
  • new label for your databases app name
  • adjust application to extension metric changes
    • bump minor version on regular development - bump patch version on hotfix change (backport)

Full version history

  • fix statement filter changing
  • Remove the details icon button from the actions column
  • change default column sorting behavior
  • db app add link from most time consuming statements to the statement details on
  • App icon changed to the one with "new"
  • fix test
  • load problems for loaded entities only
  • dependency update
  • extend problems query timeframe
  • Fix errors printed on console

Full version history

  • db app add link from most time consuming statements to the statement details on
  • App icon changed to the one with "new"
  • fix test
  • load problems for loaded entities only
  • dependency update
  • extend problems query timeframe
  • Fix errors printed on console
Dynatrace Hub
Get data into DynatraceBuild your own app
All (771)Log Management and AnalyticsKubernetesAI and LLM ObservabilityInfrastructure ObservabilitySoftware DeliveryApplication ObservabilityApplication SecurityDigital ExperienceBusiness Analytics
Filter
Type
Built and maintained by
Deployment model
SaaS
  • SaaS
  • Managed
Partner FinderBecome a partnerDynatrace Developer

Discover recent additions to Dynatrace

Problems logo

Problems

Analyze abnormal system behavior and performance problems detected by Davis AI.

Logs logo

Logs

Explore all your logs without writing a single query.

Security Investigator logo

Security Investigator

Fast and precise forensics for security and logs on Grail data with DQL queries.

Business Flow logo

Business Flow

Track, analyze, and optimize your critical business processes.

Cost & Carbon Optimization logo

Cost & Carbon Optimization

Track, analyze, and optimize your IT carbon footprint and public cloud costs.

Davis Anomaly Detection logo

Davis Anomaly Detection

Detect anomalies in timeseries using the Davis AI

Analyze your data

Understand your data better with deep insights and clear visualizations.

Notebooks logo

Notebooks

Create powerful, data-driven documents for custom analytics and collaboration.

Dashboards logo

Dashboards

Transform complex data into clear visualizations with custom dashboards.

Automate your processes

Turn data and answers into actions, securely, and at scale.

Workflows logo

Workflows

Automate tasks in your IT landscape, remediate problems, and visualize processes

Jira logo

Jira

Create, query, comment, transition, and resolve Jira tickets within workflows.

Slack logo

Slack

Automate Slack messaging for security incidents, attacks, remediation, and more.

Secure your cloud application

See vulnerabilities and attacks in your environment.

Security Overview logo

Security Overview

Get a comprehensive overview of the security of your applications.

Code-Level Vulnerabilities logo

Code-Level Vulnerabilities

Detect vulnerabilities in your code in real time.

Threats & Exploits logo

Threats & Exploits

Understand, triage, and investigate application security findings and alerts.

Are you looking for something different?

We have hundreds of apps, extensions, and other technologies to customize your environment

Leverage our newest innovations of Dynatrace Saas

Kick-start your app creation

Kick-start your app creation

Whether you’re a beginner or a pro, Dynatrace Developer has the tools and support you need to create incredible apps with minimal effort.
Go to Dynatrace Developer
Upgrading from Dynatrace Managed to SaaS

Upgrading from Dynatrace Managed to SaaS

Drive innovation, speed, and agility in your organization by seamlessly and securely upgrading.
Learn More
Log Management and Analytics

Log Management and Analytics

Innovate faster and more efficiently with unified log management and log analytics for actionable insights and automation.
Learn more