Configuring Database Monitoring

This document describes how to configure a database agent and see database metrics on the AppDynamics controller.

Feature Snapshot

  • AppDynamics supports database monitoring in v1.1.1 and later
  • If your AppDynamics controller has license for Database monitoring, you can monitor databases in PCF
  • Supported database agent v4.1.8.0, v4.1.10.0
  • Supported databases: DBSupport
  • The database agent is compatible with controller v4.1.8.0 and above OR v4.1.10.0 and above if using agent v4.1.8.0 or v4.1.10.0 respectively.

Step 1: Configure Tile for Database Agent

  1. You can configure any service plan to deploy database agents. To configure a database agent:

    1. Select the Enable Database Monitoring checkbox.
    2. Specify a supported database agent version. This tile supports database agent v4.1.8.0 and v4.1.10.0.
    3. Specify the number of database agents to deploy for the service plan.
    4. Click Save.
      DB Config For Tile GUI
  2. After the tile installs, you can verify that each database agent runs as a Cloud Foundry (CF) application within the AppDynamics-DB-Visibility org. The name of each database agent application is DBAgent-SERVICE_PLAN_NAME-INDEX. See the following example:

      $ cf target -o AppDynamics-DB-Visibility 
      $ cf apps 
      Getting apps in org AppDynamics-DB-Visibility / space AppDynamics-DB-Visibility-space as admin... 
      OK 
      name     requested      state      instances    memory         disk     urls 
      DBAgent-svcplan-1    started     1/1     1G     1G 
      DBAgent-svcplan-2    started     1/1     1G     1G
    Here, svcplan is the name of the service plan configured to deploy two DB agents.

Step 2: Configure Database Collector

The database agent and the AppDynamics controller work together to monitor a database. The agent collects the data from the database server and passes it to the AppDynamics Controller for interpretation and display in the Controller UI. The database agent does not need to be installed on the same system hosting the database server.

Note: Because each database agent starts with 1G of memory, AppDynamics reccommends configuring at most two DB collectors for each database agent app running in Pivotal Cloud Foundry (PCF).

  1. Open the AppDynamics controller and go to Databases > Configuration > Collectors. Database collector

  2. Configure a database collector using the Configure Database Collectors topic from the AppDynamics docs.

    • For the Database Agent field in every collector, select the database agent name deployed in PCF. In the example image below, you choose DBAgent-PCF-Public-Controller-1 as the Database Agent and not Default DB Agent CollectorConfig
  3. Once you configure and save the collector, generate some traffic on an application that includes database operations. After a couple of minutes, you can see database traffic on your AppDynamics Database Dashboard. DatabaseTraffic

Create a pull request or raise an issue on the source for this page in GitHub