On this page:

Related pages:


View Database Activity in Database Visibility

Once you have configured a database Collector in AppDynamics Monitoring, you can access Database Visibility either from the AppDynamics Home page or you can link to the Database Visibility database instance Dashboard by right-clicking the database and selecting View in Database Visibility on the Application Flow Map, Tier Flow Map or Node Flow Map. 

Database backends with the same hostname, port number, and database type as a database server already configured in a database Collector are automatically matched with the Collector, and drill downs from the Application Flow Map, Tier Flow Map or Node Flow Map to Database Visibility are enabled.

The AppDynamics Database Visibility section in the Application Database Dashboard displays which database Collector is associated with the database. To change this association, click Configure mapping and choose another database collector.

View Business Transaction Snapshot Correlated Database Details

Available for Java applications and their Oracle database backends, Snapshot correlation shows the details of queries, clients, sessions, and schemas around the time when the business transaction snapshot was captured.

To see the correlated database details 

  1. From a list of business transactions with snapshots, choose a longer running business transaction that accesses the database, one that takes a few seconds or more. These are more likely to have captured database details.
  2. Double-click Drill Down above the database icon. The correlated database details window appears. 
  3. Click the QueriesClientsSessions, and Schema tabs to view details of database activity that occurred around the time when the snapshot was captured.

To enable snapshot correlation, you must enable the jdbc-dbcam-integration-enabled node property for the Java Agent.