Configuring Database Monitoring
This document describes how to configure a database agent and see database metrics on the AppDynamics controller.
- If your AppDynamics controller has license for Database monitoring, you can monitor databases in PCF.
- Supported database agent v22.214.171.124
- Supported databases:
- The database agent and controller compatibility is decided on the agent version. If you are using agent v126.96.36.199, the controller should be on version v4.2.x or higher.
You can configure any service plan to deploy database agents. To configure a database agent, do the following:
- Select the Enable Database Monitoring checkbox.
- Specify a supported database agent version.
- Specify the number of database agents to deploy for the service plan.
- Click Save.
After the tile installs, you can verify that each database agent runs as a Cloud Foundry (CF) application within the
AppDynamics-DB-Visibilityorg. 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 1 G 1 G DBAgent-svcplan-2 started 1/1 1 G 1 GHere,
svcplanis the name of the service plan configured to deploy two DB agents.
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 1 G of memory, AppDynamics reccommends configuring at most two DB collectors for each database agent app running in Pivotal Cloud Foundry (PCF).
Open the AppDynamics controller and go to Databases > Configuration > Collectors.
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.
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.