Measure Database Performance

Splunk AppDynamics collects metrics for database calls and response times at the following levels:

  • Business transaction metrics: The metrics for a specific business transaction for a specific database are visible on the transaction flow map.
  • Tier metrics: The metrics for all calls from a tier to the specified database are visible on the tier flow map.
  • Database call metrics: The overall database access metrics across the application (all business transactions) are visible on the application flow map and the Database Calls dashboard.
  • Integrated database metrics withDatabase Visibility:
    • When a database Collector has been set up in Splunk AppDynamics Database Visibility, you can link to that product from the Application and Database Calls dashboards. If you have already associated the database server with a Database Collector in Database Visibility, you can view the Database Visibility UI. If not, the disconnected database icon is displayed and you are prompted to link the database to an already configured server or cluster in Database Visibility. Also, you must have view permission to the corresponding collector configured in Database Visibility, to map/un-map it with the database server or cluster.
    • A relational database backend of a Java application has the same hostname, port number, and database type as a database server already configured in a database Collector. The Oracle backend is automatically matched with the correspondingDatabase VisibilityCollector. The Snapshot correlation view, which is available for relational database backends, shows the details of queries, clients, sessions, and schemas when the snapshot was captured.
    • When a backend database is linked to a server or a cluster in Database Visibility, clicking the database icon displays basic details with a link to Database VisibilityUI. You can also view the database KPI metrics.
      Database KPI Metrics

By default, many databases and data stores are automatically detected when calls are made from nodes instrumented with Splunk AppDynamics app agents. See Access Database Visibility from Application Monitoring Views.

To monitor call performance to a database, confirm that it appears in the Databases Calls list and has its own Database Calls dashboard. If a database is not appearing, check the configuration.

The database icons on the flow maps help you identify the status of the database. The following table lists the different database icons:

Database Icon Status
The database is healthy. No active health rule violations
Health Rule Violation - Critical Condition
Health Rule Violation - Warning Condition
The database is either not linked to the appropriate server or cluster node. This icon also appears when the database is in the process of changing the state.

The database is not connected to the server or cluster inDatabase Visibility.

Click the database icon, then theConnectlink to link the database backend to the appropriate server or cluster.