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.
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
- 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.
- Double-click Drill Down above the database icon. The correlated database details window appears.
- Click the Queries, Clients, Sessions, 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.