Configuring Database Monitoring
This document describes how to configure a database agent and see database metrics on the AppDynamics controller.
- 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 v220.127.116.11, v18.104.22.168
- Supported databases:
- The database agent is compatible with controller v22.214.171.124 and above OR v126.96.36.199 and above if using agent v188.8.131.52 or v184.108.40.206 respectively.
You can configure any service plan to deploy database agents. To configure a database agent:
- Select the Enable Database Monitoring checkbox.
- Specify a supported database agent version. This tile supports database agent v220.127.116.11 and v18.104.22.168.
- 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 1G 1G DBAgent-svcplan-2 started 1/1 1G 1GHere,
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 1G 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.